Pie and Donut Chart

Pie and donut charts

Pie and donut charts are a good way to visualise data as a percentage of a total.

Plot options

You can create pie and donut charts charts from the PAGE ELEMENTS section of your workbook's editor panel, or directly from an existing data element.

Required fields

• COLOR (1 column)

• VALUE (1+ columns) Columns added to the VALUE field are aggregated by default. Aggregation type (e.g. Sum vs Count) is dependent on the original column’s value type (e.g. text, number, date, etc). Example: A numeric column [Sales Amount] will create a new calculated column [Sum of Sales Amount].

Marks

• TOOLTIP: choose columns to show when hovering over points in the chart

• TRELLIS: select columns to serve as Trellis Rows or Columns, splitting the chart into separate charts

Donut hole value

If you're creating a donut chart, you can optionally add a KPI to the hole of the donut.

1. Select the element.

   The editor panel opens to the Element properties section.

2. For Donut hole value, select the + to add a calculation.

3. Add a new column, select the row count, or choose a column to aggregate and display in the donut hole.

   The aggregate value appears with the column name as a default label. You can format the value using the format options.

Format options

To start editing the format options for a chart:

Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.

1. In the editor panel, select Element format.

2. Select a format option to view and edit its settings.