Creating a multi-dataset chart
Note
In multi-dataset charts, only linked dimensions (available in all datasets) can be used.
To create a multi-dataset chart:
Warning
If you use a new DataLens object model with workbooks and collections:
- Go to the DataLens home page. In the left-hand panel, select Collections and workbooks.
- Open the workbook, click Create in the top-right corner, and select the appropriate object.
Follow the guide from step 3.
-
Go to the DataLens home page.
-
Click Create chart.
-
Under Dataset, select a dataset for visualization. If you do not have a dataset, create one.
-
Add another dataset. To do this, under the dataset list, click Add dataset and select the dataset to visualize.
-
When you add a dataset, a link is automatically created based on the first field name and data type match. In the dataset link configuration window that opens, click Save.
-
Repeat steps 3-4 as required.
-
Select the chart type, e.g., Line chart.
-
Drag one of the linked dimensions to the X section. The values will be displayed in the lower part of the chart on the X axis.
-
Drag measures from different datasets to the Y section. The values will be displayed as charts on the Y axis.
-
Drag a dimension or measure from the dataset to the Filters section. The field can be empty. In this case, no filters are applied.
ClickHouse® is a registered trademark of ClickHouse, Inc.