Widgets

Every kind of widget a report can hold, how to add each one, and every setting in the Configure widget dialog.

A report holds six kinds of widget. You add all of them from one dialog.

Add a widget

In edit mode click Add widget (or the plus on a row). The Add to this report dialog offers:

Choice What it adds What you pick
Chart, table or metric — "Write or generate a query" A widget with its own query. Opens the Query workspace; button Write the query. The view is chosen in the workspace.
Saved query — "Pin one from the library" A widget showing a saved query. Saved query, then Show it as: A chart, A headline number or A table. A saved query can be pinned as a headline number anywhere on the page, as well as in a KPI row.
Note — "Context in a few words" A text block. Title (optional) and Text. Markdown works: bold, lists, links.
Form — "Fill it in on the page" A form embedded on the page. A published form.
Button — "Opens a form in a dialog" A button that opens a form in a window. A published form.

Only published forms can be added. With none you see "No published forms yet — publish one in the Forms app first." With no saved queries you see "No saved queries yet."

How each kind looks

  • Metric — one big number, optionally with a small trend line, a change arrow and progress to a target.
  • Chart — Line, Bar, Horizontal bar (ranking), Donut (share), Area, stacked and 100% stacked bars, Bar + line, Funnel, Pivot table, Gauge or an India map. See Chart types. The default Auto chart picks from the shape of the result. Named categories default to the ranking bar, dates to a line.
  • Table — rows and columns that scroll inside the card.
  • Note, Form, Button — text, an inline form, or an action button.

Numbers are formatted by what the column looks like: money uses your workspace currency, percentages show as percent, dates as dates. Names like invoice numbers or years are never formatted as amounts.

Drill into the records

Click a bar, a donut slice (or its name in the legend) or a table row to open the records behind it — for example, click Paid on an invoices-by-status chart to see the paid invoices, filtered.

This works when the widget's query reads one record type and the label column is a field of that type, such as SELECT status, COUNT(*) FROM invoices GROUP BY status. Charts over joins, calculated labels such as dates, and line charts do not drill. The list opens filtered by the clicked value only; other conditions in the widget's query, such as a date range, are not carried over.

Configure a widget

In edit mode open the widget's Widget options menu and choose Configure…. The Configure widget dialog changes when you click Done.

Chart, table or metric widgets

Setting Notes
Title Defaults to the saved query name, or "Untitled widget".
Visualisation Auto chart, Line, Bar, Horizontal bar (ranking), Donut (share), Area, Stacked bar, 100% stacked bar, Stacked area, Bar + line, Funnel, Pivot table, Gauge, India map, Table (see Chart types). Table is not offered in a KPI row.
Variables One box per {{name}} in the query. Blank uses the default; "No default — required" means you must fill it. See Variables and time range.

Metric widgets

Setting Options
Headline — when the query returns many rows, how they fold into one number Sum, Latest, Average, Minimum, Maximum
Comparison Automatic, Against the previous period, Later half against the earlier half, None
Compared with (caption) Text such as "last month"
Good news is A rise (revenue, sign-ups) or A fall (overdue, complaints). Controls whether an increase shows green or red.

A metric query can also return a column named previous (or prev, prior, last_period) to show a percentage change, and a column named target (or goal) to show progress towards it.

Note: Title (optional) and Text.

Button: Form, Label (defaults to the form name), Icon (a row of ten icons), After submit: Close the form or Keep it open for another entry.

Form: Form and Label.

Other widget actions

The Widget options menu also has Edit query (or Open saved query when the widget is pinned to one) and Remove. You can also right-click a widget title bar.

Limits

  • Up to 32 query widgets (chart, table or metric) in one report.
  • See Arrange a report for rows, sections and widths.