Counting Distinct Parameter IDs Per Session in Mixpanel
Hi everyone, I have a question about aggregating properties at the session level. In my case, I have an App Session event, and within each session there can be multiple events that carry a parameter (let’s call it parameter_id). What I want: Count the number of distinct parameter_id values within each session - basically the same way Mixpanel lets you create a computed property at the user level (e.g., “count distinct parameter_id per user”), but instead scoped to the session. What I don’t want:
Doing a total distinct count across all data, then dividing by the number of sessions (which is just an average).
I need an actual per-session value, so that each session has its own distinct count of that property, and I can analyze distributions or break it down further.
From what I’ve seen, Mixpanel’s computed properties allow user-level aggregation, but I can’t find an equivalent for session-level distinct counts. Is there a way to do this in the current UI, or a workaround? Thanks!
