Counting unique values per session ID

[rsAU]

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

[rsAU]

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

[ITWhisperer]

| stats dc(field) by sessionID

[bowesmana · Accepted solution]

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"