Pie chart

A pie chart (or donut) shows how slices add up to a whole. Use it for a small number of categories. Prefer a bar chart when there are many slices or the values are close together.

Label field

labelField is the slice name — gender, region, plan, status.

Value field

valueField is the numeric size of the slice — a count or an amount. The query should already have one row per label (use GROUP BY).

Chart options

  • Donut style — hollow center.
  • Show labels — default on.

Example query

SELECT
  status,
  COUNT(*) AS tickets
FROM support_tickets
WHERE account_id = :customer_id
GROUP BY status