Change the Chart or Table
Choose a Chart Type
- Click 'Visualization' at the bottom left.
- Click a chart type.
- Click 'Done'.
- Use the small table / chart switch at the bottom to flip between the data table and the chart.
The picker lists the chart types that suit your data.
Note: When you change a saved report (filter, summarize, chart type) the original is not overwritten. The header shows 'Started from' and the report name, and the changes only become permanent if you click 'Save'. This makes it safe to experiment.
Chart Types
| Chart | Good for |
| Table | Looking at the raw rows. |
| Bar | Comparing counts across categories. This is the default for grouped data. |
| Row | Horizontal bars. Good for long category names. Small categories are combined into 'Other'. |
| Line | Values in time order. With categories such as vendors, the line simply joins the points. |
| Area | Like Line, with the area under the line filled in. |
| Combo | Mixing a line and bars in one chart when you have more than one measure. |
| Pie | Share of a whole. Shows a legend, percentages and the total in the centre. |
| Pivot Table | A grouped table with totals. |
| Funnel | Ordered stages that narrow down. Use it only for steps that follow each other. For plain categories it gives a confusing shape. |
| Waterfall | A running total shown as steps up or down. Good for showing how parts add up to a total. |
| Scatter | Two numeric fields plotted against each other. It stays empty until you choose two numeric fields in the chart settings. |
| Map | Colours regions on a map from a state or region field. It stays blank unless the report has a region field. |
| Detail | One record at a time ('Item 1 of 107') with next and previous arrows. Good for reading one row in full. |
| Number, Trend, Gauge, Progress | A single value, or a value against a goal. These appear in the picker when the result is one number, for example a total count. |
The list adapts to your data, so not every chart is offered for every report.
Fine-Tune a Chart
- Click the gear next to 'Visualization' (or the gear on the selected chart type).
- 'Data' - choose the X-axis field and the Y-axis series.
- 'Display' - turn on 'Goal line' or 'Show values on data points'.
- 'Axes' - set 'Show label', 'Label', 'Show lines and marks' and 'Scale' for each axis.
- Click 'Done'.
Chart settings open on the left with the 'Data', 'Display' and 'Axes' tabs.
