NQL sum()

The sum() function returns the total sum of a numeric column.

users
| include web.events during past 24h
| where application.name == "Salesforce"
| compute usage_duration = duration.sum()
| where usage_duration != 0
| sort usage_duration desc

Username	AD → Full name	Usage duration
jmansel@kanopy	Jessy Mansel	34min 20s
lahmir@kanopy	Latrell Ahmir	26min 16s
abilete@kanopy	Adhibhaar Bilete	25min 46s
kkamilah@kanopy	Kolton Mariam Kamilah	24min 53s
jadnan@kanopy	Jimmie Adnan	24min 47s
bkyrie@kanopy	Braedyn Branden Kyrie	24min 7s
melyssa@kanopy	Micah Mackenna Elyssa	23min 6s
csami@kanopy	Cody Treyton Sami	23min 3s