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
UsernameAD → Full nameUsage 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

Last updated

#451: 2024.8-Overview of integration DOC

Change request updated