Pie chart

This topic contains an example of the pie chart type.

The following Analytics statement contains one GROUP BY and a single metric:

RETURN NumCases AS SELECT 
    SUM("Number of Cases Sold") AS "Total Cases Sold" 
GROUP BY "Business Types"

It produces a pie chart summarizing the "Total Cases Sold" metric for each Business Type:

Important: The pie chart type only supports a single GROUP BY statement. If you have multiple GROUP BYs in your statements, the chart will not display or execute drill-down as expected.