Donut chart

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

Product categories	Sales
Home appliances	69M
Household goods	57M
Household cleaners	44M

You can highlight multiple small segments belonging to a larger category with the same color.

Wizard sectionsWizard 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, 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 chartCreating a donut chart

To create a donut chart:

1. Go to the DataLens home page.
2. In the left-hand panel, select Charts.
3. Click Create chart → Chart.
4. At the top left, click Select dataset and specify the dataset to visualize.
5. Select Donut chart as the chart type.
6. Drag a dimension from the dataset to the Categories section.
7. Drag a dimension or measure from the dataset to the Color section.
8. 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 .
2. In the Chart settings window, disable the Results option.
3. Click Apply.

RecommendationsRecommendations

• If there are many segments, the chart looks cluttered and it becomes difficult to understand 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 in your dataset or chart.

  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
             

  2. Drag the new field to the Color section.

  3. 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; for other subcategories, in the Other group.

  

• Combine small segments into larger groups:

  • Use the Categories section to highlight segments.
  • Use the Color section to highlight groups.

• 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.

See alsoSee also

• Creating a dashboard in DataLens
• Adding a chart to a dashboard
• Adding a selector to a dashboard