Donut chart
Written by
Updated at October 23, 2024
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.
Source table
| Year | Sales |
|---|---|
| 2022 | 6М |
| 2021 | 28М |
| 2020 | 18М |
| 2019 | 9М |
| 2018 | 1М |
Wizard sections
| Wizard section |
Description |
|---|---|
| Color | Dimension. You can only specify one field here. |
| 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. Сalculations using LOD expressions, window functions, and time series functions 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 dimension to this section. Markup functions are supported. For String type fields, you can configure using basic Markdown syntax: click the icon before the field name and enable Markdown. |
| Filters | Dimension or measure. Used as a filter. |
Creating a donut chart
To create a donut 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 4.
- Go to the DataLens home page.
- In the left-hand panel, select Charts.
- Click Create chart → Chart.
- At the top left, click Select dataset and specify the dataset to visualize.
- Select Donut chart as the chart type.
- Drag a dimension or measure from the dataset to the Color section.
- 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:
- In the top-left part of the screen, click .
- In the Chart settings window, disable the Results option.
- Click Apply.
Recommendations
- If there are more than 4-6 segments per chart, group the smallest of them as Other. A larger number of segments overloads a chart and makes it difficult to understand the data.
- You cannot display negative and null values on this type of chart.
- Do not use donut charts to show changes to proportions over time or for precisely comparing data by category.