Table sheets
A sheet that is one table, filling the tab, that people work on directly
Overview
A Table sheet is a dashboard tab that holds one table and nothing else. The table fills the tab, with its own toolbar on top and a Columns panel at the side, so the people who view it work on the table itself: search it, sort and filter its columns, choose, order, pin and rename columns, and download it.
Use one when the table is the point: a list of orders to work through, accounts to review, or a report people slice and export. For charts, KPIs and several tables on one page, use a dashboard sheet.
A Table sheet starts with every row of its data. Group the rows by a field to make a summary, spread a field's values across columns for a cross-tab, or write the table in SQL.
Add a Table sheet
- Click Edit on the dashboard.
- Click + Sheet at the end of the sheet tabs and choose Table.
- In New table sheet:
- Name: the tab's name.
- Data: the dataset or table the table reads. The dashboard's usual data is selected; pick another from the list, search it, or choose Browse all data for any other dataset or a table in one of your connections.
- Click Create sheet.
The new sheet opens with the Columns panel open. Under Add a field, click a field to add it as a column. The search at the top of the panel finds both the table's columns and the fields you can add.
Nothing is saved until you click Save. Discard removes the sheet with your other unsaved changes.
Group and spread
While you edit the dashboard, two lanes sit above the table:
- Rows: click Group by and check the fields to group rows by, in order: the first is the top level, the next splits it. The picker stays open, so you can check several in a row; a date groups by year, or by quarter from its ···.
- Columns: click Spread to spread a field's values across columns, one column per value for each measure.
Grouping turns every row into a summary. Number columns become measures (summed by default), and other columns leave the table; a notice names them. When nothing is a number, the summary counts rows. Remove the last level and the last spread field, with the × on its chip, and the table shows every row again.
A grouped table shows as:
- Collapsible: levels that open and close, with subtotals.
- Flat: one row per group, paged by row. Best for long lists and export.
Switch between them from the toolbar. Your measures, highlights and settings carry over where the other shape has them; a notice names anything that doesn't.
Shape the table
The sheet's toolbar and menus also have the author's controls:
- Totals adds or removes a total row.
- Columns opens the panel at the side. It lists what the rows are grouped by and spread across, then the columns or measures: drag a column to reorder it, uncheck it to hide it, choose how a measure adds up, and × to remove it from the table. Click a column's name to open its settings beside it. Add a field lists the fields you can add.
- The + after the last column header adds a column without opening the panel: search for a field and click it.
- The settings button sets what viewers can change: customize columns, filter columns and search.
Each column's ··· menu adds:
- Pin to the left, Move left and Right.
- Group rows by a column, or Spread across columns.
- Column settings…: the column's label, date grain and format, number format, and for a measure, how it adds up, a running total or other calculation, and conditions on what it counts. These are the same settings as the card editor's.
- Highlight cells… on a number column: color cells or rows by rules on that column's values. A column with highlights shows a brush in the Columns panel.
- Hide column keeps the column in the table, out of sight. Remove column takes it out of the table.
What you set here is the table everyone starts from. A table written in SQL keeps its columns' order, names and pins here; change its query with Open in card editor in the ··· menu.
Work on the table
Everyone who views the sheet, in the app or in a dashboard embedded in your product, can:
- Search the table from the toolbar.
- See records behind a grouped row or a cell, from the cell.
- Sort and filter a column from its ··· menu.
- Open Columns to hide, reorder and rename columns for themselves, and pin or move one from its ··· menu, when the author allows it. See Customize table columns.
- Export the table from the toolbar, as it is filtered and sorted. See CSV downloads and Excel downloads.
- Save the table as they've arranged it in a view.
What a viewer changes is theirs: nobody else's table changes.
Filters, exports and reports
- Dashboard filters can reach a Table sheet like any other sheet; pick it in the filter's sheets.
- A PDF of the dashboard, or a scheduled report, includes the Table sheet's table.
- The table has the dashboard's theme.
Ask an agent
Agents connected through the MCP can add a Table sheet with its table in one change, and then change the table like any card: its columns, settings and pins. A Table sheet always holds exactly one table, so an agent can't add another card to it, remove its table, or arrange it.