NQL summarize
The summarize
statement condenses the information into a single result.
Syntax
...
| summarize <new metric name> = <metric>.<aggregation function>
Examples
Compute the average value of the number of page views per device.
devices
| with web.page_views from Jun 1 to Jun 7
| compute num_navigations = number_of_page_views.sum()
| summarize average_num_navigation_per_device = num_navigations.avg()
average_num_navigation_per_device |
---|
115.9 |
Count the number of devices active in the last 7 days. In case of the count()
aggregation function, you can omit the filed name before the aggregation to count the number of records of the root table.
devices during past 7d
| summarize number_of_devices = count()
number_of_devices |
---|
285 |
Compute the total size of all the binaries.
binaries during past 7d
| summarize total_size = size.sum()
total_size |
---|
611.3 GB |