KQL Search

Query Details

HomeAI ToolsDevice Query

Data Type Usage Pie Chart

Query

// Usage by data types in a pie chart
Usage
| summarize count_per_type=count() by DataType
| sort by count_per_type desc
| render piechart

Explanation

This query is used to create a pie chart that shows the usage of different data types. It counts the number of occurrences for each data type, sorts them in descending order, and then renders the results in a pie chart.

Details

Rod Trent profile picture

Rod Trent

Released: January 7, 2021

Tables

Usage

Keywords

Usage,DataType,summarize,count_per_type,sort,render,piechart

Operators

summarizecount()bysort bydescrenderpiechart

Actions