NQL sumif()

The sumif() command summarizes values from the rows that match specified criteria. It accepts extra arguments, the conditions that determine which rows to include.

devices during past 24h
| include web.page_views during past 24h
| where application.name == "Confluence"
| compute total_cnt = page_view.number_of_page_views.sumif(page_view.experience_level == frustrating)
| sort total_cnt desc
| limit 10

Name

Entity

Hardware → Device model

Hardware → Device type

Operating system -> Name

Total cnt

Last updated 5 months ago