Adding a hierarchy to charts in DataLens On-premises

To add a hierarchy:

1. Go to the workbook and select the chart.

2. On the left side of the screen above the list of dimensions and measures, click and select Hierarchy.

   

3. Enter the hierarchy name, select dimensions, and arrange them as needed.

   

4. In the bottom-right corner, click Save.

5. Drag your hierarchy to any available section. For example, for a Table chart, you can use the Columns section.

6. Drag other dimensions and measures to the appropriate sections.

7. In the top-right corner, click Save.

Example of adding a hierarchyExample of adding a hierarchy

As our data source, we will use a ClickHouse® demo database with a Moscow retail chain's sales data. For an example of creating a connection and dataset, see this guide.

1. In the top-right corner of the dataset, click Create chart.

2. Select the Donut chart visualization type.

3. Add a sales measure to the chart. To do this, drag the Sales field from Measures to the Measures section.

4. On the left side of the screen above the list of dataset fields, click and select Hierarchy.

5. Enter Products as the hierarchy name and select the dimensions in the following order: ProductCategory, ProductSubcategory, ProductBrand, and ProductName.

6. In the bottom-right corner, click Save.

7. Drag your hierarchy to the Color section.

8. Save the chart:

   1. In the top-right corner, click Save.
   2. In the window that opens, enter Donut chart with hierarchy as the chart name and click Save.

Adding the hierarchy to the chart will allow you to switch between levels of detail: ProductCategory → ProductSubcategory → ProductBrand → ProductName.

Check out some examples of charts with a hierarchy on our ready-made dashboard.

Useful linksUseful links

• Creating a tree.

ClickHouse® is a registered trademark of ClickHouse, Inc.