How to filter users by event count in Insights reports
How to filter out users from an Insights report who have only done X or less events in a given timeframe?
How to filter out users from an Insights report who have only done X or less events in a given timeframe?
Hi Shane, 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 with a behavioral Computed Property and then use it as a filter in Insights.1. In the Insights report, add a Computed Property of type “Frequency per User”.
2. Choose the specific event X whose count you care about.
3. Set the time range for the computation to match your analysis window (per-interval or full date range, depending on your chart type). [Computed props]
4. Once created, use this Computed Property in the Filter section of the report, and set a condition like:
- Frequency per User of <event X> ≤ NThis will filter the report to only users who did that event N times or fewer in the selected timeframe. Behavioral properties like “Frequency per User” are explicitly designed to let you segment or filter users by how many times they did an event. [Computed props]
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.
Let me check the knowledge base for you again. One moment! 📚
For a 12‑month Insights report, Per Interval means: - If your chart interval is Monthly: the frequency is computed separately for each month in that 12‑month range. - If your chart interval is Daily/Weekly: it’s computed per day/week respectively across that 12‑month range. In bar/table/pie views, Per Interval uses the entire date range you selected (i.e., the full 12 months) as the interval. [Computed props] So: - If you want “users who did ≤ X events over the whole last 12 months”, use a bar/table/pie view with Per Interval and a 12‑month date range. - If you want “per‑month” limits (e.g., ≤ X events in any given month), use a line chart with Monthly granularity; Per Interval will then apply per month. [Computed props]
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.