Ad Hoc View – Dual Pie Chart

Pie charts display values as slices of a circular graph. The Dual level pie chart allows multiple measures to be displayed in concentric circles.  Data requirements for Dual-Level Pies are different to those for standard Pie Charts. Charts allow you to graphically display your data. There are a number of different chart types available.


Step 1.  Open or create a new ad hoc view (refer to Creating Ad Hoc Views article for further information) Step 2. Click on the Select Visualisation Type icon in the top menu
Visualisation Type Icon
The Select Visualisation Type window is displayed
Step 3. Select Pie from the Chart Types list There are three pie charts available: Each chart type displays your data in slightly different ways. Step 4. Click on Dual-Level Pie Chart.
Tip: Dual-Level Pie Charts must have at least one measure (count of clients) and one field (Primary Address City).

Only one field can be placed in the Rows area if the box contains a measure.

Two fields can be placed in the rows area if the box contains no measures.

Multiple measures can be added to rows, but only one to columns.
Step 4.  Click and drag a measure from the measures area on the left-hand side pane to a column. Select a measure e.g. Count of Clients Step 5. Add a field from the Fields area on the left-hand side to a row. Dual-Pie add field e.g. Primary Address City The chart displays the total for the measure in the inner circle. The outer circle shows the measure split by the field. Dual-Level Pie Chart Step 6. To break up the measure further, add another field to the rows section. E.g. gender Dual-Level Pie rows and columns The inner circle displays Count of Clients for each Primary Address City. The outer circle breaks those areas by gender. Dual-Level Pie Chart Note – to make the chart clearer, we have added a filter to only show a subset of data. For more information on Filters, refer to the Ad Hoc View – Filters article.

Further Information

For further information on Ad Hoc Views and Charts, refer to the following articles:
Updated on April 30, 2020

Related Articles