Pivot

Add a pivot to a table, including date filtering, date grains, formatting, and more

{% pivot value="date" date_grain="year" /%}

Attributes

value · String · required

fmt · String

date_grain

Time grain for date truncation (default: day for date columns)

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

sort · String

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

Allowed values:

• asc
• desc

Allowed Parents

• table