kapa.ai I have an event called all events in my mixpanel dash that measures the count of all events I’ve created. i am trying to measure the average total events per user but based on cumulative data month to month rather than standalone, non-cumulative data. how can i create a insight chart that reflects the average total events per user based on the cumulative count of events month to month rather than teh non cumulative data?
Please stand by Anirudh C. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To create an Insights chart in Mixpanel that shows the average total events per user, using cumulative data month-to-month (rather than standalone, non-cumulative data), follow these steps: 1. Create an Insights Report Start a new Insights report and select your "all events" event.2. Set the Measurement In the measurement dropdown (usually defaults to "Unique Users"), select "Frequency per User" or "Total Events" per user. This will calculate the number of events each user performed in the selected time interval.3. Set the Time Interval Set the time interval to "Monthly" in the date picker or time granularity settings.4. Enable Cumulative Analysis In the advanced measurement or analysis settings, enable the "Cumulative" option. This will add up the values of each point on the graph as it goes along, so the height of the line increases over time, reflecting the cumulative count rather than just the events in each standalone month. > Cumulative: Adds up the values of each point on the graph as it goes along, so the height of the line will increase over time. Insights: Analysis Settings5. Interpret the Chart The resulting line chart will show, for each month, the cumulative average number of events per user up to that month.Summary: - Use "Frequency per User" or "Total Events" as your measurement. - Set the interval to "Monthly." - Enable the "Cumulative" analysis setting to get a running total month-to-month.This approach will give you a cumulative view of average total events per user, rather than a non-cumulative (standalone) monthly view.For more details, see the documentation on Measurements and Analysis Settings.
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.
