Documentation › Charts
Choosing a chart type
Which chart type to use for which question - trends, comparisons, shares, distributions, KPIs, tables and maps.
The right chart makes the answer obvious at a glance. Start from the question you are answering.
| Question | Good chart types |
|---|---|
| How is it changing over time? | Line Chart, Area Chart, Bar Chart (by month), Smooth Line |
| What's the one number that matters? | Big Number, Big Number with Trendline |
| How do categories compare? | Bar Chart (horizontal for long names), Table |
| What is the share of each part? | Pie Chart (up to about 6 slices), Treemap, Bar Chart (stacked, 100%) |
| How is it spread out? | Histogram, Box Plot |
| How do two measures relate? | Scatter Plot, Bubble Chart |
| Where is it happening? | Country Map, World Map, Point Cluster Map. See Maps and ISO codes |
| How does a target compare to actual? | Gauge Chart, Bullet Chart, Mixed Chart (bars and a line) |
| Where do things flow? | Sankey Chart, Funnel Chart |
| What's in the detail? | Table, Pivot Table |
| Something custom (a card, a list, a formatted message)? | Handlebars. See Handlebars charts |
Most-used charts
- Big Number with Trendline
- A headline figure with a small trend line under it and the change against the previous period. Choose the metric, the date column and the Time grain. Use Comparison Period Lag to compare with, say, 12 months earlier.
- Bar Chart
- Compares categories or time periods. Put a column in X-axis and one or more Metrics; add a Dimension to split bars by, say, region. Stack series in Customize stacks them.
- Line Chart
- Shows trends. The X-axis is a date column with a Time grain. Add a Dimension for one line per category. Use Advanced analytics for rolling averages.
- Mixed Chart
- Two queries in one chart, for example revenue as bars and margin % as a line on a second axis.
- Table
- Rows and columns, with sorting, search and pagination. Query mode: Aggregate groups rows (one row per branch with its totals). Raw records lists rows as they are. Conditional formatting colours cells by value.
- Pivot Table
- Cross-tabulates one measure by two dimensions (branches down, months across), with subtotals and totals.
- Pie Chart
- Shares of a whole. Keep it to a few slices: set Row limit to 5 or 6 and the rest are grouped as Other. A bar chart is often easier to read.
Tips
- One message per chart. If you need to explain two things, make two charts.
- Start the value axis at zero for bar charts, so bar lengths compare fairly.
- Use the same colours for the same things across a dashboard: the colour scheme does this for you when the values match.
- Write the unit in the title or axis title: Revenue (UGX, millions).
Something unclear or missing? Tell us and we'll improve this page.