KQL Search

Query Details

HomeAI ToolsDevice Query

Billabledatavolumebysolution

Query

//Billable data volume by solution
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), Solution | render barchart

Explanation

This query calculates the billable data volume for each solution. It filters the data to include only the past 32 days and then further narrows it down to the past 31 days. It also filters out any non-billable data. The query then summarizes the billable data volume in gigabytes by grouping it based on the start time and solution. Finally, it visualizes the results in a bar chart.

Details

Rod Trent profile picture

Rod Trent

Released: July 15, 2020

Tables

Usage

Keywords

Usage,TimeGenerated,StartTime,EndTime,IsBillable,Quantity,BillableDataGB,Solution,render

Operators

|where>ago>=startofdayand<now==truesummarizesum/1000binrender

Actions