Query Details
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 piechart
Explanation
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
Devices,Intune,User
Operators
externaldatasort byrender