Report Builder
Report Builder
The Report Builder is where you turn a dataset into a chart. This guide explains the editor itself — adding columns, renaming them, the toolbar, the resizable edit panel, and how preview works versus saving.
The layout
When you create or edit a report you see three areas:
| Area | What it does |
|---|---|
| Available Columns (left) | Every column from the chosen dataset |
| Zones (middle) | X-Axis / Dimension, Y-Axis / Metrics (or Group By / Metrics, or Rows / Columns / Values for pivots) |
| Live Preview (right) | The chart, updating as you build |
Top bar: Dataset, Report Name, Filter, Save Report.
Available Columns
- Search — type to find a column by name.
- Type filters —
All·Text·Numeric·Dateshow only that type. - Checkboxes — tick the columns you want.
- Select all — tick every visible column at once.
Three ways to add a column to a zone
- Drag & drop — drag a column into a zone.
- Select + move — tick one or more columns, then click the move button (e.g. → X-Axis / → Y-Axis) to send all ticked columns at once.
- Add field — use the + Add field button inside a zone (below).
Tip: To add many columns quickly, use Select all and then the move-to-axis button.
Add field (inside a zone)
Each zone has an + Add field button:
- Click + Add field.
- A dropdown opens with a search box and the column list.
- Click a column → it’s added to that zone.
The dropdown wraps across rows and scrolls when there are many columns, so nothing is cut off.
Column chips — rename & actions
Each column in a zone is shown as a chip:
Rename a column (double-click to edit)
- Double-click the column name.
- It becomes an input box and the cursor focuses automatically.
- Type the new name.
- Press Enter (or click away) to confirm.
Rules:
- A name cannot be empty. If you clear it and press Enter, you get a warning (“Column name cannot be empty”) and the input stays open and focused until you type a value.
- Only one name is editable at a time.
- A blank name also blocks Save Report as a safety check.
Chip actions
- Filter — add a filter on this column.
- Sort — change sort direction.
- Settings (⚙) — formatting: number / currency / date, decimals, aggregation, etc.
- Delete (✕) — remove the column from the zone.
Hover a long, truncated name → a tooltip shows the full text.
Chart toolbar (styling the preview)
Above the preview chart, a toolbar styles the visualization:
| Button | Purpose |
|---|---|
| Rows | Row filter / limit |
| Style | Text & label styling |
| Color | Colors, gradients, background |
| Axis | Axis labels (for axis-based charts) |
| More / Config | Extra chart-specific options |
| Table | Table view options |
Toolbar changes also follow the preview-only rule (see below).
Preview vs Save — important
This is the key behaviour to understand:
| Action | Result |
|---|---|
| Add / remove / rename columns, change settings or toolbar | Preview only — the chart updates, but nothing is saved |
| Click Save Report | The report is saved permanently |
| Go back without Save Report | Changes are discarded — nothing is written |
So you can experiment freely. Only Save Report writes to the database. If you accidentally add the wrong columns, just press Back — nothing was saved.
Editing from the View page (resizable panel)
Open a saved report and click Edit — the builder opens as a side panel next to the chart:
- It opens at a comfortable default width (~500px) so the columns and zones aren’t squished.
- Drag the handle between the chart and the panel to resize it wider or narrower.
- Available Columns and the zones use the full panel width, so column names show on one line.
Quick walkthrough
Tips & gotchas
- Nothing saves until “Save Report”. Editing only previews.
- Empty column name is not allowed — you’ll be kept in the input until you type one.
- One name edits at a time — opening a second closes the first.
- Long names truncate with
…— hover for the full name. - Select all + move is the fastest way to add many columns.
- Resize the edit panel on the view page by dragging the handle.
- Validation messages (e.g. “Add at least one Metric column”) only apply to a real build/save — they won’t nag you mid-setup.
- Filter vs Save Report are styled differently on purpose: Filter is a secondary (outline) button, Save Report is the primary (solid green) action.