Creating a multi-dataset chart

Written by

Updated at August 31, 2026

Note

In multi-dataset charts, you can only use linked dimensions, i.e., those available in all datasets.

Warning

If you use the 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 object you need.

Proceed with this guide from Step 3.

Go to the DataLens main page.
In the left-hand panel, click Charts.
Click Create chart → Chart in Wizard.
Under Dataset, select the 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 appear in the lower part of the chart on the X axis.
Drag measures from different datasets to the Y section. The values will appear 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.