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
... View more