numbering rows by field name?

[Yarsa]

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:)

[Ayn · Accepted solution]

If you have one event per session, you can use streamstats to create a count per user:

... | streamstats count AS session_number by user