Overview
A Table Chart renders dataset rows and columns as a structured tabular view. Tables are the most customizable chart type in Lens — the Properties panel exposes Table-wide settings (header styling, scrolling, sorting, search, pagination, aggregation, conditional formatting, etc.) and per-column settings (display name, type, drilldown, heat map, hide/freeze/width, grouping, binning, etc.).
Table Charts are authored from Lens → Design → Chart Designer → Visualization → Table. The Properties panel for a Table splits into two tabs: Properties (Table-wide) and Columns (per-column). Each tab carries multiple property groups that are documented in the structural sections below.
When to use it
- Detailed row-and-column data presentation where every value matters.
- Multi-column views where users will sort, filter, search, or drill down per column.
- Aggregated summaries (sum, count, average) on numeric measures.
- Conditional formatting use cases — coloring cells based on comparisons with other columns.
- Pivot views over a single measure with optional heat-map shading.
- Cases where the chart needs an action column with buttons or icons gated by permissions.
Building blocks
| Datasource | The data source the Table queries against. Selected from the dropdown above the column tree. |
| Dataset | A specific table or view within the Datasource. Expanded from the Datasource entry. |
| Dimension | Columns used as grouping fields. |
| Measure | Columns used as numeric values. Aggregations (sum / count / average) and number formatting apply to Measures. |
Properties tab — Table-wide settings
| Title | Title text, title background, show title inside chart, horizontal alignment, font, size, weight, color. |
| Header | Hide header, background color, content color, font style, font size, view angle, horizontal alignment, vertical alignment, font weight, row height, show bottom border. |
| Scroll Bar | On/off toggle; horizontal scroll bar width; vertical scroll bar width. |
| Line Properties | Vertical line, horizontal line, table border toggles; horizontal line color and thickness. |
| Colors | Content color; primary and secondary alternate-row colors; title background and font; header color; header content color; horizontal line color; table background; no-records color. |
| Content Properties | Color, checkbox column, word wrap, Dashboard column resize, row height. |
| Column Properties | Group columns; arrange in order; High Cardinality Column for stable sort order on large datasets. |
| Sorting & Filters | Sorting toggle (ascending/descending), single column sorting, sort icon position, Show Sort Bar (with column choice, alignment, label, Default Column Sort), Show Filters On Column. |
| Search | Show Search Bar toggle, column, apply search on focus out, alignment, label. |
| Aggregate | Enable Column Aggregate; Aggregate Column Setting (name, position, type, currency name, format, format suffix, unit orientation, precision, column width, header color, header content color, content color). |
| Action Column | Add Action Column toggle; display name; action type; select type (e.g., button or icon); font style; background color; button text color; icon library or upload; select permissions; column content alignment. |
| Pivot Data | Pivot the Data toggle; measure for pivot; Show Pivot Heat Map with Min Heat and Max Heat colors. |
| Table Column Setting | Conditional formatting — select a Column, a Condition, and other columns to compare against; pick a color for matching values. |
| Tooltip Options | Table-wide tooltip toggle; tooltip property selection. Note: column-level tooltips are configured per-column in the Columns tab. |
| Row Settings | Custom Row function (Label name, Row, Operator, Row, Add Groups); default records limit. |
| Padding | Padding Left, Padding Right; units in px, pt, cm, rem, or %. |
| Pagination | Page size; primary, secondary, and sequence colors; shape toggle; Custom Paging option. |
| Adhoc Report | Adhoc Report toggle; Generate and Send to Inbox actions; default records limit. Generated reports download as PDF or Excel. |
| Highlight On Click | Row to highlight on click; default row number for initial highlight. |
| No Records Setting | Template type; title; description; font family, size, weight, color; text alignment for the empty-state display. |
| Data Limit Settings | Disable Pagination for a fixed record count; custom message at end of data with font family, color, size, weight, and padding. |
Columns tab — per-column settings
Per-column settings are accessed by switching to the Columns tab and clicking a column. Most settings apply to both Measure and Dimension columns; three additional settings (Groups, Bins, Invert Rows) are available only on Dimension columns.
| Header | Both | Header color, header content color, font style, font size, hide header, view angle, alignment, font weight. |
| Display Name | Both | Display name; Display Name Word Wrap. |
| Content Properties | Both | Color, checkbox column, word wrap, Dashboard column resize, row height. |
| 1st Level Header | Both | 1st Level Title, 1st Level Word Wrap, 1st Level Header Alignment, 1st Level Vertical Alignment. |
| 2nd Level Header | Both | 2nd Level Title, 2nd Level Word Wrap, 2nd Level Header Alignment, 2nd Level Vertical Alignment. |
| Sorting & Filter | Both | Sorting toggle, sort icon position, Show Filters On Column with restricted values. |
| Image | Both | Enable Image toggle; upload image (replaces header); height and width adjustment. |
| Tooltip Options | Both | Per-column tooltip toggle; tooltip property selection. |
| Type | Both | Currency, date, month, quarter, number, percentage. Currency exposes name, format, unit orientation, precision (on Measure columns). |
| Drilldown | Both | Drilldown target (Chart or Report); measure for drilldown; drilldown name; Drilldown Type (pop-up, Inline, External, Fit to chart); pop-up view and orientation; Apply Filter on click; Pass Row on click; fields to pass as filter. |
| Heat Map | Both | Show heat map toggle; min heat color; max heat color. |
| Aggregate | Measure only | Sum / count / average aggregation; label name for the column. |
| Column Settings | Both | Hide column; freeze column; hide column on condition; column width. |
| Groups | Dimension only | Group name; fields; enable group; optional Others category for remaining rows. |
| Bins | Dimension only | Create bin toggle; bin name; Lower Range; Higher Range. |
| Invert Rows | Dimension only | Single toggle that pivots the data. |
Drilldown
Drilldown is a per-column setting in the Columns tab that wires a click on a column value to open another Chart or Report. It is the primary mechanism for hierarchical exploration in a Table — clicking a category drills into a detail view of that category.
| Target | Chart or Report to open on click. Selected from a dropdown of Charts and Reports in the Workbook. |
| Measure for drilldown | Measure value passed to the target. |
| Drilldown name | Identifier for the drilldown configuration. |
| Drilldown Type | How the target opens. Pop-up opens a modal (with configurable view and orientation); Inline opens in place; External opens as an external link; Fit to chart sizes the target to the parent Chart’s area. |
| Apply Filter on click | Toggle. When on, the column’s value is applied as a filter to the target. |
| Pass Row on click | Toggle. When on, the full clicked row’s fields are passed; the fields used as filter values are selectable. |
Drilldown is overridden by the Disable Drilldown option on the parent Report’s widget three-dot menu. Both must be aligned for drilldown to work at view time.
Key behaviors
Table-wide vs. per-column scope. The Properties tab applies settings to the entire Table; the Columns tab applies settings to one selected column. Settings appear in both places only when they make sense at both scopes — Tooltip Options, Sorting & Filter, and Header are dual-scope; Pagination, Search, and Action Column are Table-wide only; Drilldown, Heat Map, Bins, and Groups are per-column only.
Measure vs. Dimension column shapes. Measure columns expose number-format settings (currency, format, precision) and the Aggregate option. Dimension columns expose Groups, Bins, and Invert Rows. The other per-column settings apply to both.
Tooltip scope. The Tooltip Options group on the Properties tab enables tooltips for the entire Table; the Tooltip Options on a column overrides Table-wide and applies just to that column. Both scopes carry independent property selection.
Pivot Data and Heat Map combine. Pivot Data restructures the Table around a chosen measure; the Show Pivot Heat Map toggle adds color shading from Min Heat to Max Heat to make hotspots visible. Heat Map is independently available per-column on non-pivoted Tables as well.