Format and organize a table

The Table widget displays query results as a structured grid — rows and columns with full control over how each column looks, sorts, and highlights values.

​

Before you begin

Add a table using the dashboard editor or reuse a result from the Analyst or Query Bench. You need editing access to save table settings.

​

Open table settings

1. Choose More options → Edit manually on the dashboard.
2. Open the widget’s Table Settings control.
3. Use Settings for the title, default sorting, and overall style; Schema for individual columns; and Group, Pivot, or Click Behaviour where available.
4. Review the preview, select Save Changes, then save the dashboard edits.

​

Reading the data

Each row in the table corresponds to one row returned by the underlying query. Column headers are the field names from your query — you can rename them inside the widget without changing the query itself. The table paginates automatically for large result sets. The total row count is shown in the widget footer. Null values mean data is missing. Do not interpret them as zero. Check the underlying query if the distinction matters to your analysis. Numbers, dates, and text are all displayed as returned by the database. Use column controls to add prefixes, suffixes, or formatting on top of the raw values.

​

Sorting and filtering

Open the widget settings to set a default sort: Viewers can click any column header to sort interactively — this overrides the default sort for their session without changing the saved configuration. Filter data lets you apply a persistent filter condition to the query results (e.g. show only rows where status = "active"). This filter is applied before the table renders and is not visible to viewers as a control.

​

Column controls

Open Schema in the table settings and expand the column you want to configure. Column controls and available formats depend on its data type. Prefix and suffix are purely visual — they do not change the underlying value used in sorts or calculations.

​

Conditional formatting

Conditional formatting lets you apply styles to individual cells based on their value. Open the column’s conditional-formatting control from the table settings or its header menu.

​

Single color rules

Rules are evaluated top-to-bottom. The first matching rule wins. Each rule has a condition and a style to apply when that condition is true. Condition types: Style options per rule: Any combination of styles can be applied in a single rule.

​

Color scale

The Scale tab in conditional formatting applies a continuous color gradient across the column’s values — useful for quickly spotting high and low values in numeric columns. Configure three anchor points: Anchor types: Values between anchor points receive interpolated colors. Values outside the defined range receive the nearest anchor color.

​

Table style

Open Settings → Table Styling to pick a preset, wrap header titles, or wrap long cell text.

​

Custom style

Choose Custom to set header and banding colors. Review the table in both themes; the controls edit the colors for the theme currently shown.

​

Pinned columns

Pinned columns stay fixed at the left edge of the table while the remaining columns scroll horizontally. Useful for identifier columns (e.g. name, ID) that viewers need to keep visible. Use the column header’s pin action to keep an identifier such as a customer name visible while you scroll across the table. Review the result on a narrow screen so pinned columns do not take up all the available space.

​

Column order

Arrange columns in the order readers need them, with identifiers before measures. Check the table preview and save the settings when the order is ready.

​

Group, pivot, and click behaviour

Use Group to organize rows into expandable summaries; see Group and expand rows. Use Pivot when you want a cross-tab comparison instead of a long list. Click Behaviour controls row highlighting, cell selection, and whether clicks apply dashboard filters. It also contains the Context Menu, Records, and Drill Through controls. Filter Mapping connects renamed display columns to their actual source columns.

​

Expected result

The table opens with readable labels, useful number formats, and the intended default sort. Readers can find the relevant rows and use the interactions you enabled.

​

Next steps

Filter from a table value or export table data.