How do I set a new column which specifies the occurence order of events, grouped by another field.
For example - users Y,X and Z had 5 sessions each.
How can I number their sessions from 1 to 5, so I can choose to analyze only data from their second session.
Thanks:)
If you have one event per session, you can use streamstats
to create a count per user:
... | streamstats count AS session_number by user
If you have one event per session, you can use streamstats
to create a count per user:
... | streamstats count AS session_number by user