how do i breakdown an event per the count of the event per user
Hi Gabriel W., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
You can do this using a behavioral computed property called Frequency per User, then use it in a breakdown.In an Insights report: 1. Select your event as the Metric (e.g. “Play Video”). 2. Click on Breakdown. 3. Choose Computed Properties → Behavioral Properties → Frequency per User. 4. Select the same event whose per‑user count you care about. 5. Apply (and optionally adjust buckets if offered).This computes “how many times each user did this event” over the selected time range/interval, and then breaks down your metric by that per‑user count. [Computed props; Insights measurements]If you instead want to filter (not break down), you can use the same Frequency per User behavioral property in the Filters section.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai when i do this i see total events of action event_name >= 8 times, 7 times, 4 times and for each there is an event count eg. 8 times 49 events, 8,7,5,3,2 for the rest. This doesn't make sense becuase i am filtering a cohort that only has 52 people in it.
Let me check the knowledge base for you again. One moment! 📚
What you’re seeing is expected behavior, even with a 52‑user cohort.Key points: 1. Frequency per User is per user, but your metric is still “Total Events” - The behavioral property “Frequency per User” classifies users into buckets like “≥ 8 times”, “7 times”, etc. [Computed props] - When you then use Total Events as the measurement, the number shown (e.g. “8 times → 49 events”) is the total count of events done by all users in that bucket, not the number of users. [Measurements]2. Users can generate many events - With only 52 users, it’s still easy to get 49+ events in a bucket if a few users did the event many times. - So “8 times → 49 events” means: “All users who did this event ≥ 8 times generated 49 events in total,” not “49 users did it ≥ 8 times.”3. How to sanity‑check - Change the measurement from Total Events to Unique Users to see how many users are in each “Frequency per User” bucket. [Users] - Or use the cohort as a breakdown instead of a filter to see “In cohort / Not in cohort” counts. [Cohorts in analysis]If you still see impossible numbers after switching the measurement to Unique Users, the docs don’t provide more specific causes; you’d then want to double‑check filters, time range, and that the cohort definition really limits to those 52 users. [Data discrepancies]
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
