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
Last updated
Was this helpful?