Pivot chart
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Displays a pivot table and chart. You can interactively select data, columns, rows, and various chart types.
Note
- This visualization can only be used in the context of the render operator.
- This visualization can be used in Kusto.Explorer but is not available in the Azure Data Explorer web UI.
Syntax
T | render pivotchart
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string |
✔️ | Input table name. |
Example
SalesFact
| join kind= inner Products on ProductKey
| where ProductCategoryName has "Computers" and ProductName has "Contoso"
| where DateKey between (datetime(2006-12-31) .. datetime(2007-02-01))
| project SalesAmount, ProductName, DateKey
| render pivotchart
