Pivot

Use a pivot for a compact cross-tab with one row dimension, one column dimension, and one metric.

Key fields

visuals:
  category_pivot:
    type: pivot
    title: Order count by category and status
    query:
      type: pivot
      rows:
      - category
      columns:
      - status
      metrics:
      - order_count
    presentation:
      type: table
      rowHeight: 32
      showHeader: true
      striped: false

Conditional-format targets may name the visible row field or metric alias. Pivot column dimensions generate headers and are not visible target columns.

API reference

Kind: grid. Renderer: tanstack. Supported result shapes: pivot_window.

Field	Type	Default	Allowed values	Description
`type`	`string`	—	`table` `matrix` `pivot`	Selects the tabular visual behavior.
`query`	`tabular query`	—	—	Selects record fields or grouped row, column, and metric fields.
`cardinality`	`string`	—	`bounded` `exact`	Controls whether the visual resolves an exact row count.
`presentation.rowHeight`	`integer`	`required`	`positive integer`	Sets the tabular row height.
`presentation.showHeader`	`boolean`	`true`	`true` `false`	Shows semantic table headers.

Accessibility. Tabular visuals expose semantic headers and virtualized rows while preserving keyboard navigation.