Use the built-in “Frequency per User” measurement in Insights. It calculates the number of events performed per user and lets you aggregate the per-user values (e.g., Average, distribution, median, percentiles, min, max). No custom formula is required. In an Insights report, pick your event, change the measurement from “Total Events” to “Frequency per User,” then choose the aggregation you want (Average is the default) (Insights / Measurements, Aggregate Property per User).
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.
Hi Rachel V., 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