Charts & Visualisations
After running a report you can switch from the table view to a chart view to visualise the data. Charts are generated in the browser from the same data the table displays.
Switching to Chart view
Click the Chart button in the Table / Chart toggle above the results. The system fetches all matching rows (not just the current page) so the chart represents the full dataset.
Chart types
Use the Chart type dropdown to choose a visualisation style:
Chart type | Best for |
Bar Chart | Comparing categories side-by-side |
Horizontal Bar | Categories with long labels or many groups |
Line Chart | Trends over time or sequential data |
Pie Chart | Showing proportions of a whole |
Doughnut Chart | Same as pie with a hollow centre |
Configuring axes
Two additional dropdowns control what the chart shows:
Label axis — the column used for category labels (typically a text or date field). Defaults to the first text column in your report.
Value axis — the numeric column to measure, or "Count (rows)" to simply count how many rows fall into each category. Defaults to the first numeric column, or Count if none exist.
The chart automatically groups rows by the label column and either sums the value column or counts rows.
Display limits
Charts show the top 20 groups by value, sorted highest to lowest. A summary line below the chart shows how many groups are displayed out of the total, along with the overall row count.
Labels longer than 40 characters are truncated.
Saving a chart as an image
Click Save Image in the chart header to download the current chart as a PNG file. The file is named chart-YYYY-MM-DD.png using today's date.
Dark mode
Charts automatically adapt their colours, grid lines, and tooltips to match your current theme (light or dark mode).