Dashboard referenceReference
Each row on a Report_ sheet configures one widget with these columns:
| Column | What it does |
|---|---|
| Widget | “kpi”, “chart”, “pivot”, “table”, “filter”, “measure” or “title”. |
| Title | The tile's heading, translatable via the Translation_ sheet. A chart names itself (“Measure by Group”), so its Title cell isn't shown. |
| Form / Section | Which form's records to read — and, for a form with line items, whether to read the header or the LINE ITEMS. |
| Measure / Aggregate | What to total: a field (or * to count rows) and how — sum, average, count, distinct count, min, max, median, % of total or % of group. A pivot may list several, comma-separated. |
| Rows / Columns | Group by these fields; comma-separate to nest. A date can bucket: order_date by month (also quarter / year). For a flat “table”, this lists the columns to show instead. |
| Chart | For a chart widget: bar, line, area, pie or donut. |
| Filter | Limit the data, e.g. status = 'Shipped' — the same grammar as the Rules sheet. |
| Width | Optional width on the 12-column grid: a number (1–12) or full / half / third / quarter. Blank uses the widget type's default. |
Header vs. line items. The Section column picks the grain. A header section totals one row per record; LINE ITEMS totals one row per line — and a line measure can still group by a header field, like revenue by region. A header field only ever groups there; totalling it per line would double-count.
Derived dimensions. A Rows or Columns field doesn't have to exist on the form. Use an attribute of a master-data field — category from product — or a part of a date — year from order_date (also quarter, month, day). Derived fields also work as flat-table columns, as filter-bar fields, and in the viewers' group-by pickers.
The filter bar. Viewers can filter the whole page by any header dimension. Add a filter row (naming fields in its Columns cell) to curate which appear by default — viewers can still add or remove fields themselves, and long value lists get a search box and Select all.
Several dashboards. Each Report_ sheet becomes its own page, shown as tabs in workbook order.
Adding, changing & deleting. Dashboards live in your workbook: edit it and re-upload through Change app. A new Report_ sheet adds a dashboard; removing the sheet deletes it.
Localized. Titles translate through the Translation_ sheet (Object Type widget, report or measure); dropdown values via the List_ language columns; and every number, date and currency is formatted for the viewer's region.