Query Details
Billable Databy Data Type
Query
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
Explanation
This query is looking at usage data within the last 32 days. It filters the data to only include records with a start time within the last 31 days and an end time before today. It then calculates the sum of the quantity divided by 1000 for each day and data type, and labels the result as "BillableDataGB".
Details
Rod Trent
Released: May 5, 2020
Tables
Usage
Keywords
Usage,TimeGenerated,StartTime,EndTime,IsBillable,Quantity,BillableDataGB,DataType
Operators
|where>ago>=startofdayand<nowsummarize=sum/1000binDataType