Calculate Sumof Column
Query
//An example of how to calculate a column of data. This query retrieves the number of ActivityStatusValue records from the AzureActivity table then shows a single result of the total calculated (sum) value.
AzureActivity
| summarize count() by ActivityStatusValue
| summarize sum(count_)Explanation
This query calculates the total number of records in the AzureActivity table based on different values in the ActivityStatusValue column. It then calculates the sum of these counts to give a single result.
Details
Rod Trent
Released: July 25, 2022
Tables
AzureActivity
Keywords
AzureActivityActivityStatusValuecount()summarizesum(count_)
Operators
|summarizecount()bysum()