---
metadata:
- name: generator
content: Diplodoc Platform v5.63.0
alternate:
- en/visualization-ref/ring-chart
- ru/visualization-ref/ring-chart
- href: en/visualization-ref/ring-chart.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/visualization-ref/ring-chart.html
title: Donut chart in DataLens On-premises
description: >-
In this tutorial, you will learn how to create and customize the donut chart
visualization type in DataLens On-premises.
vcsPath: en/visualization-ref/ring-chart.md
---
# Donut chart in DataLens On-premises
This chart shows the proportion of different categories using ring segments. The sum of all segments is 100%. The size of each segment matches the percentage of a category in the total amount. A number in the center of a ring depends on the selected measure and indicates the overall total.
Donut charts are a good choice if you need to display a small number of segments.
{% cut "Example" %}
{% list tabs %}
- Visualization
- Source table
Product categories | Sales |
-----|---------|
Home appliances | 69M |
Household goods | 57M |
Household cleaners | 44M |
{% endlist %}
{% endcut %}
You can highlight multiple small segments belonging to a larger category with the same color.
{% cut "Example" %}
{% endcut %}
## Wizard sections {#wizard-sections}
Wizard section| Description
----- | ----
Categories | Dimension. You can specify only one field here. Your data will be grouped by this field.
Color | Dimension. You can specify only one field here. Your charts segments will be colored according to it.
Measures | Affects the size of ring segments. You can only specify one field here. The total value of a measure is displayed in the center of a ring. Calculations using [LOD expressions](../concepts/lod-aggregation.md), [window functions](../function-ref/window-functions.md), and [time series functions](../function-ref/time-series-functions.md) are not presented in the total value.
Sorting | Measure or dimension from the **Color** section. Affects segment sorting. The sorting direction is marked with an icon next to the field: for ascending or for descending. To change the sorting direction, click the icon.
Labels | Measure. Displays measure values on the chart. To add callouts with category names to the chart, drag the [Measure Names](../concepts/chart/measure-values.md) dimension to this section. [Markup functions](../function-ref/markup-functions.md) are supported. For `String` type fields, you can configure using basic [Markdown in DataLens On-premises](../dashboard/markdown.md) syntax: click the icon before the field name and enable **Markdown**.
Filters | Dimension or measure. Used as a filter.
## Creating a donut chart {#create-diagram}
To create a donut chart:
{% note warning %}
If you use the new DataLens object model with [workbooks and collections](../workbooks-collections/index.md):
1. Go to the DataLens home page.
1. Open the workbook, click **Create** in the top-right corner, and select the object you need.
Follow the guide from step 4.
{% endnote %}
1.
Go to the DataLens home page.
1.
In the left-hand panel, select **Charts**.
1.
Click **Create chart** → **Chart**.
1.
At the top left, click **Select dataset** and specify the dataset to visualize. If you do not have a dataset, [create one](../dataset/create-dataset.md#create).
1. Select **Donut chart** as the chart type.
1. Drag a dimension from the dataset to the **Categories** section.
1. Drag a dimension or measure from the dataset to the **Color** section.
1. Drag a measure from the dataset to the **Measures** section. The values will be displayed as donut chart segments.
To disable displaying a number in the center:
1. In the top-left part of the screen, click .
1. In the **Chart settings** window, disable the **Results** option.
1. Click **Apply**.
## Recommendations {#recommendations}
{% note info %}
You cannot display negative and null values on this type of chart.
{% endnote %}
* **Segments.** With too many segments, your chart will look cluttered, making it difficult to interpret the data. If there are more than 4-6 segments in one chart, consider combining the smallest of them into one segment, e.g., `Other`. You can do this by processing the data, e.g., by creating a [calculated field](../concepts/calculations/index.md) in your dataset or chart.
{% cut "Example of combining segments in a chart" %}
**Source table**
ProductSubcategory | Sales |
-----|---------|
Beauty and health products | 11M |
Kitchenware | 34M |
Kitchen products | 23M |
Detergents | 22.5M |
Health and beauty equipment | 35M |
Non-essential goods | 23M |
Cleaners | 21.5M |
To combine multiple segments by the `ProductSubcategory` field into a joined group:
1. Add a new field to the chart with the following formula:
```
CASE [ProductSubcategory]
WHEN "Beauty and health equipment" THEN "Beauty and health equipment"
WHEN "Kitchen" THEN "Kitchen"
WHEN "Kitchenware" THEN "Kitchenware"
ELSE "Other"
END
```
1. Drag the new field to the **Color** section.
1. Drag the `Sales` field to the **Measures** and **Signatures** sections.
The sales amount will be calculated separately for the `Beauty and health equipment`, `Kitchen`, and `Kitchenware` subcategories, while for other subcategories, in the `Other` group.
{% endcut %}
* Combine small segments into larger groups:
* Use the **Categories** section to highlight segments.
* Use the **Color** section to highlight groups.
* Do not use donut charts to show changes to proportions over time or for precisely comparing data by category.
#### Useful links {#see-also}
* [Creating a dashboard in DataLens On-premises](../operations/dashboard/create.md)
* [Adding a chart to a dashboard in DataLens On-premises](../operations/dashboard/add-chart.md)
* [Adding a selector to a dashboard in DataLens On-premises](../operations/dashboard/add-selector.md)