topic Counting unique values per session ID in Dashboards & Visualizations

Counting unique values per session ID

rsAU — Wed, 29 Jan 2025 04:45:22 GMT

I'm trying to count the unique values of a field by the common ID (session ID) but only once (one event). Each sessionID could have multiples of each unique field value.

Initially I was getting the count of every event which isn't what I want to count and if I 'dedup' the sessionID then I only get one of the unique field values back.

Is it possible to count one event per session ID for each unique field value?

"stats values("field") by sessionID" gets me close but in the table it lists the sessionIDs whereas I'm hoping to get the number (count) of unique sessionIDs

Field	sessionID
value1	ABC123 123ABC
value2	ABC123
value3	123ABC
value4	ABC123 123ABC AABBCC 12AB3C
value5	ABC123 123ABC AABBCC 12AB3C CBA321

Hopefully that makes sense. Thanks

Re: Counting unique values per session ID

bowesmana — Wed, 29 Jan 2025 04:53:07 GMT

You question is a little confusing as the table shows the values of sessionID by field, which is what you say you wanted, but the stats is giving the values of field by sessionID, i.e. the other way round.

Are you looking for dc, i.e.

| stats dc(sessionID) as uniqueSessionCount by field

which would give you the count of different sessionIDs for each value of "field"

Re: Counting unique values per session ID

ITWhisperer — Wed, 29 Jan 2025 09:18:16 GMT

| stats dc(field) by sessionID

Re: Counting unique values per session ID

rsAU — Wed, 29 Jan 2025 22:23:26 GMT

Thanks - this is what I was after!

Yeah I was getting a list of every sessionId but I was trying to find a way to get a count of each unique ID.

Cheers, Ryan