Pivot

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

Key fields

visuals:
  category_pivot:
    type: pivot
    title: Order count by category and status
    query:
      rows:
        category: orders.category
      columns:
        status: orders.status
      measures:
        order_count: null

API reference

Kind: visual. Renderer: tabular. Supported result shapes: pivot.

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 measure fields.
`cardinality`	`string`	—	`bounded` `exact`	Controls whether the visual resolves an exact row count.

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