Analytics & Charts
Explore datasets and build bar, line, pie and candle charts.
Analytics reads the dataset produced by the latest successful execution. You can inspect raw rows, then build charts that share the same filters and ordering rules.
Connect a dataset
- 1
Open Analytics
Visit Analytics. - 2
Choose a pipeline
Only pipelines that have completed at least one successful run appear in the dropdown - a dataset stays available after a later run fails, because the materialised rows are still there. - 3
Connect
Select Explore. The first 500 rows load immediately.
Table view
The table view is your sanity check before building charts.
- Free-text search across every column.
- Click any header to sort; click again to reverse.
- Rows-per-page selector with 5, 10, 20 and 50 options.
- Sticky headers keep column names visible while you scroll.
Chart types
When to use what
| Field | Type | Description |
|---|---|---|
| Bar | string | Comparing a measure across categories — revenue by region, orders by product. |
| Line | string | Change over time — daily signups, weekly throughput. Best with a date or ordered X axis. |
| Pie | string | Share of a whole with few categories. Legends aggregate beyond eight slices into Other. |
| Donut | string | Same as pie but with the total displayed in the centre. Preferred when the total matters. |
| Candlestick | string | OHLC financial series. Requires date, open, high, low and close fields. |
Configuring a chart
Adding a chart opens a configuration panel with a live preview. The preview sits beside the form on a laptop and stacks above it on a tablet or phone, so you always see the result before saving.
| Field | Type | Description |
|---|---|---|
| Chart title | required | Shown as the card heading. |
| Description | string | Optional subtitle clarifying the metric. |
| Chart type | string | Bar, Line, Pie, Donut or Candlestick. |
| X-axis | string | Category or date field. For candlesticks this is the date. |
| Y-axis | string | Numeric measure. Replaced by OHLC fields for candlesticks. |
| Aggregate | string | How rows sharing the X value are combined - Sum, Average, Number of rows, Minimum, Maximum, or None. Applied first, before sorting. Not offered for candlesticks, which plot four raw price columns. |
| Order / Sort by | string | Sorting applied after grouping and before the row limit. |
| Take / Row limit | string | Keep the first or last N rows after sorting. Sum plus a descending sort on the measure is what produces a top-N list. |
| Width | string | Share of the row: 35%, 50%, 65% or 100%. |
Dashboard layout
Charts are arranged in rows. A row can hold any combination of widths, as long as the total does not exceed 100%. Empty space in a row shows a dashed add chart tile, so you can fill a half-empty row without leaving the dashboard.
100% one wide chart
50% + 50% two equal charts
35% + 65% one narrow, one wide
35% + 65% (full row) add tiles disappear when the row is full
Below the md breakpoint every row stacks to a single full-width chart
so tablets and phones stay readable.Responsive charts
Charts are sized by the card that holds them, not by a fixed pixel box, so the same dashboard works on a phone and on a laptop:
| Field | Type | Description |
|---|---|---|
| Phone | string | Charts render at 240px, then the dashboard scrolls normally. Legends move below a donut instead of squeezing beside it. |
| Tablet | string | Charts grow to 280px, and the rail collapses to an overlay drawer so the full width stays available for the plot. |
| Laptop and up | string | Charts grow to 320px and rows keep their declared widths, which is where a dense dashboard becomes genuinely useful. |
Every chart also carries a single accessible name — for example “Bar chart: revenue by region” — so screen readers announce what the chart shows instead of reading an unlabelled graphic.
Chart best practices
- One question per chart — split compound metrics rather than stacking them.
- Normalise dates before charting so the X axis sorts chronologically.
- Keep category counts under about twelve; aggregate the rest.
- Use the row limit rather than trying to render thousands of points.
- Prefer donut over pie when the total is meaningful to the reader.
Last reviewed October 2026.