365 Visualize365daysof Kql
Query
//Visualize the breakdown of 365 days of KQL
externaldata(Category: string, Count: int)
[
h@'https://gist.githubusercontent.com/reprise99/12487ffefee2c2c417e2706150e25b8e/raw/0679cbb29e43e370c7304bb9b3d0007042a8ad52/365daysofkql.csv'
] | sort by Count desc | render piechartExplanation
This query retrieves data from an external source that contains information about different categories and their corresponding counts. The data is then sorted in descending order based on the count and visualized as a pie chart.
Details
Matt Zorich
Released: March 7, 2022
Tables
365daysofkql
Keywords
DevicesIntuneUser
Operators
externaldatasort byrender