Hi Jade K., 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
To calculate the sum of a property per user in Mixpanel, you should use the Aggregate Property per User measurement. Here’s how you can do it: 1. In your Insights report, select the measurement option and choose Aggregate Property per User.
2. Select Sum as the aggregation function.
3. Choose the event and the numeric property you want to sum (e.g., total number of hours of videos watched per user).This will calculate the total of the selected property across all instances of the event for each user. You can further aggregate these per-user sums using options like average, distribution, median, percentiles, minimum, or maximum, depending on your analysis needs.Example:
If you want to know the total number of hours of videos watched per user, select the relevant event (e.g., "Video Watched"), choose the property (e.g., "duration"), and set the aggregation to Sum under Aggregate Property per User. You can then view the average, distribution, or other statistics of these per-user sums.For more details, see the documentation on 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.
