Pie chart

The pie chart widget displays proportional distribution across categories. It is best suited for a small number of categories (2–6) where relative share is what matters.

Use it for:

• Platform share (Steam vs iOS vs Android)
• Traffic source breakdown
• User tier distribution (free vs paid)

Note

For more than ~6 categories, a bar chart is usually easier to read.

---

Query requirements

Return one row per slice with a label column and a value column. The values can be raw counts — the frontend handles the percentage rendering automatically when Display format is set to percent.

Select: platform, count() AS count
Filters: WHERE name = 'app_started' GROUP BY platform ORDER BY count DESC

---

Display format

Set Display format to percent to show each slice as a percentage of the total. Your query stays the same — no need to compute ratios in SQL.

---

Common examples

Platform share

Select: platform, uniqExact(identity) AS count
Filters: WHERE name = 'app_started' GROUP BY platform
Display format: percent — Unit: %

---

Distribution by app version

Select: app_version, count() AS count
Filters: GROUP BY app_version ORDER BY count DESC LIMIT 6