Query Details
Billabledatavolumebydatatype
Query
//Billable data volume by data type Usage | where TimeGenerated > ago(32d) | where StartTime >= startofday(ago(31d)) and EndTime < startofday(now()) | where IsBillable == true | summarize BillableDataGB = sum(Quantity) / 1000. by bin(StartTime, 1d), DataType | render barchart
Explanation
This query calculates the billable data volume by data type over the past 31 days. It filters the usage data to only include billable data and then groups it by the start time and data type. The quantity of data is summed and converted to gigabytes. Finally, the results are displayed in a bar chart.
Details
Rod Trent
Released: July 15, 2020
Tables
Usage
Keywords
Usage,TimeGenerated,StartTime,EndTime,IsBillable,Quantity,DataType
Operators
|where>ago>=startofdayand<now==truesummarizesum/1000bybinrender