---
metadata:
- name: generator
content: Diplodoc Platform v5.63.0
alternate:
- en/operations/chart/add-hierarchy
- ru/operations/chart/add-hierarchy
- href: en/operations/chart/add-hierarchy.md
type: text/markdown
title: Markdown version
csp:
- script-src:
- https://mc.yandex.ru
img-src:
- https://mc.yandex.ru
connect-src:
- https://mc.yandex.ru
- wss://mc.yandex.ru
child-src:
- 'blob:'
- https://mc.yandex.ru
frame-src:
- 'blob:'
- https://mc.yandex.ru
frame-ancestors:
- 'blob:'
- https://mc.yandex.ru
canonical: en/operations/chart/add-hierarchy.html
title: How to add a hierarchy to charts in DataLens On-premises
description: Follow this guide to add a hierarchy to charts in DataLens On-premises.
vcsPath: en/operations/chart/add-hierarchy.md
---
# Adding a hierarchy to charts in DataLens On-premises
{% note info %}
* You cannot use hierarchies in **Map**, **Indicator**, and **Pivot table** charts.
* You can only add one hierarchy to a chart.
{% endnote %}
To add a hierarchy:
1. Go to the [workbook](../../concepts/index.md#workbooks-and-collections) and select the chart.
1. On the left side of the screen above the list of dimensions and measures, click and select **Hierarchy**.
1. Enter the hierarchy name, select dimensions, and arrange them as needed.
1. In the bottom-right corner, click **Save**.
1. Drag your hierarchy to any available section. For example, for a **Table** chart, you can use the **Columns** section.
1. Drag other dimensions and measures to the appropriate sections.
1. In the top-right corner, click **Save**.
## Example of adding a hierarchy {#add-hierarchy-example}
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](../../quickstart.md).
1. In the top-right corner of the dataset, click **Create chart**.
1. Select the **Donut chart** visualization type.
1. Add a sales measure to the chart. To do this, drag the `Sales` field from **Measures** to the **Measures** section.
1. On the left side of the screen above the list of dataset fields, click and select **Hierarchy**.
1. Enter `Products` as the hierarchy name and select the dimensions in the following order: `ProductCategory`, `ProductSubcategory`, `ProductBrand`, and `ProductName`.
1. In the bottom-right corner, click **Save**.
1. Drag your hierarchy to the **Color** section.
1. Save the chart:
1. In the top-right corner, click **Save**.
1. 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](https://datalens.yandex/9fms9uae7ip02?tab=MNb).
#### Useful links {#see-also}
* [Creating a tree](../../dataset/data-types.md#how-to-create-tree).
_ClickHouse® is a registered trademark of [ClickHouse, Inc](https://clickhouse.com)._