Pivot

{% table data="demo.daily_orders" %}
    {% dimension value="category" /%}
    {% pivot value="date" date_grain="year" /%}
    {% measure value="sum(total_sales)" fmt="usd1m" /%}
{% /table %}

Examples

Pivoted Table

{% table data="demo.daily_orders" %}
    {% dimension value="category" /%}
    {% pivot value="date" date_grain="year" /%}
    {% measure value="sum(total_sales)" fmt="usd1m" /%}
{% /table %}

Attributes

string

required

string

Bucket dates into a grain. Pass the raw date column as x and the chart truncates and groups for you. Temporal grains (day, week, month, quarter, year, hour) preserve the year — use for time-series. Seasonality grains (day of week, day of month, day of year, week of year, month of year, quarter of year) collapse across years — use for cyclical patterns like “which month sells most regardless of year”.Allowed values:

day
week
month
quarter
year
hour
day of week
day of month
day of year
week of year
month of year
quarter of year

string

Sort direction for this pivot column. When specified, the table will be sorted by this column.Allowed values:

asc
desc

Allowed Parents

table

Get Started

Core Concepts

Features

MCP

CLI

Self Host

Direct Connectors

Evidence Warehouse

Components

Examples

Pivoted Table

Attributes

Allowed Parents

​Examples

​Pivoted Table

​Attributes

​Allowed Parents

Examples

Pivoted Table

Attributes

Allowed Parents