Tracking Average Comments on Ideas for Event Insights

I have an event “comment on idea” this is where we track when people leave a comment. I want to see how many ideas in average ideas have. We have a property for the event called “Idea name” this helps us find which idea the comment was made on.

2 comments

kapa.ai
APP
·
·
Hi Ege T., 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
kapa.ai
APP
·
·
Based on your question, you want to analyze how many comments are made on ideas on average. You have an event called "comment on idea" with a property "Idea name" that identifies which idea received the comment.To find the average number of comments per idea, you can use Mixpanel's "Aggregate Property" measurement in the Insights report with the "Distinct count" function. Here's how to do it: 1. Go to the Insights report 2. Select your "comment on idea" event 3. Change the measurement from "Unique Users" to "Aggregate Property" 4. Select "Distinct count" as the function 5. Choose "Idea name" as the property to countThis will give you the total number of unique ideas that received comments in your selected time period. Then, to get the average number of comments per idea, you can: 1. Create a formula that divides the total number of "comment on idea" events by the distinct count of "Idea name"Alternatively, you could use the "Aggregate Property per User" measurement with the following approach: 1. Change the measurement to "Aggregate Property per User" 2. Select "Distinct count" as the function 3. Choose "Idea name" as the property 4. For the aggregation option, select "Average"This approach would calculate how many distinct ideas each user commented on, and then average that across users, which is different from your original question.For your specific need (average comments per idea), I recommend using the first approach with a formula or using Mixpanel's Custom Properties feature to create a calculated metric.Mixpanel Insights Measurements provides more details on the different measurement options available.
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.