Time pivot visualization

This article describes the time pivot visualization.

The time pivot visualization is an interactive navigation over the events time-line pivoting on time axis.

Syntax

T | render timepivot [with (propertyName = propertyValue [, …])]

Parameters

Name	Type	Required	Description
T	`string`	✔️	Input table name.
propertyName, propertyValue	`string`		A comma-separated list of key-value property pairs. See supported properties.

Supported properties

All properties are optional.

PropertyName	PropertyValue
`accumulate`	Whether the value of each measure gets added to all its predecessors. (`true` or `false`)
`legend`	Whether to display a legend or not (`visible` or `hidden`).
`series`	Comma-delimited list of columns whose combined per-record values define the series that record belongs to.
`ymin`	The minimum value to be displayed on Y-axis.
`ymax`	The maximum value to be displayed on Y-axis.
`title`	The title of the visualization (of type `string`).
`xaxis`	How to scale the x-axis (`linear` or `log`).
`xcolumn`	Which column in the result is used for the x-axis.
`xtitle`	The title of the x-axis (of type `string`).
`yaxis`	How to scale the y-axis (`linear` or `log`).
`ycolumns`	Comma-delimited list of columns that consist of the values provided per value of the x column.
`ytitle`	The title of the y-axis (of type `string`).

Example

This query outputs a visualization of flood events in the specified Midwestern states, displayed as a time pivot chart.

let midwesternStates = dynamic([
    "ILLINOIS", "INDIANA", "IOWA", "KANSAS", "MICHIGAN", "MINNESOTA",
    "MISSOURI", "NEBRASKA", "NORTH DAKOTA", "OHIO", "SOUTH DAKOTA", "WISCONSIN"
]);
StormEvents
| where EventType == "Flood" and State in (midwesternStates)
| render timepivot with (xcolumn=State)

Output

:::image type=“content” source=“media/visualization-timepivot/time-pivot-visualization.jpg” lightbox=“media/visualization-timepivot/time-pivot-visualization.jpg” alt-text=“Screenshot of timepivot in Kusto.Explorer.”:::

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.