Hi, I have created a user property by the name of totalbilledamount. That shows me the total amount charged from the user. I am looking to create a metric where I want to know the total revenue, that is the sum of totalbilledamount of all the users. What should be a way around for this?
Hi Muhammad U., 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 total revenue as the sum of the totalbilledamount property across all users, you should use the Aggregate Property measurement in a Mixpanel Insights report. Here’s how you can do it: 1. Go to the Insights report in Mixpanel. 2. Select “Aggregate Property” as your measurement. 3. Choose your event (or use “Profiles” if you want to aggregate across user profiles). 4. Select the property totalbilledamount. 5. Set the aggregation function to Sum.This will give you the total sum of totalbilledamount across all users, which represents your total revenue.For reference, the documentation states: > The total of a numeric property value across all user profiles. Example: What’s the total revenue across all users? Docs: Aggregate PropertyIf you are using an event property instead of a profile property, the same approach applies—just select the relevant event and property.Let me know if you need step-by-step screenshots or further clarification!
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 Yes, I need step-by-step screenshots or further clarification.
Let me check the knowledge base for you again. One moment! 📚
Certainly! Here’s a step-by-step guide to calculate the total revenue (sum of totalbilledamount across all users) in Mixpanel Insights. While I cannot provide screenshots, I will give you clear, actionable steps based on the official documentation: ---
How to Calculate Total Revenue (Sum of totalbilledamount) in Mixpanel
1. Open Insights Report - Go to your Mixpanel project and navigate to the Insights report.2. Select Measurement - At the top of the report, click on the measurement dropdown (it may default to "Unique Users" or "Total Events"). - Select Aggregate Property from the dropdown.3. Choose Data Source - If totalbilledamount is a user profile property, select Profiles as your data source. - If it’s an event property, select the relevant event.4. Select Property - In the property selection, choose totalbilledamount.5. Set Aggregation Function - Set the aggregation function to Sum.6. Run the Report - The report will now display the total sum of totalbilledamount across all users, representing your total revenue.---Reference:
The total of a numeric property value across all user profiles. Example: What’s the total revenue across all users?
Docs: Aggregate PropertyIf you need to aggregate per user and then sum, you can use Aggregate Property per User with the sum function as well, depending on your data structure Aggregate Property per User.If you have any trouble finding these options in the UI, let me know which step you’re stuck on and I can clarify further!
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.