Hey all, in the Insights report, is it possible to group an event property to aggregate the event’s count? Here’s an example to illustrate better:
I have Event A, with Event Property B that is a string. Event A can be triggered multiple times while having the same Event Property B, or different ones. So I could have A {B: “one”} triggered 10 times for User1, and also A {B: “two”} triggered 3 times for User1 as well. User2 could have A {B: “three”} triggered 5 times.
Now what I want to do is to generate the report such that it will tell me on average, for each distinct Event Property B, how many times Event A happened?
I tried visualizing using the Breakdown by Event Property B in the report but there are too many distinct Bs that it wouldn’t help get the data.
Any idea if this is possible and how to do it?
Best answer by Peishan
Thanks for the clarification!
So from what I understand, here’s an example of your event setup, where the $distinct_id denotes your individual user, whereas your project_id denotes the project that the user is using.
Event Name | $distinct_id | project_id |
Edit Photo | Elvin | abc |
Edit Photo | Elvin | abc |
Edit Photo | Elvin | def |
Edit Photo | Peishan | xyz |
Right now, in your project, you easily calculate the average events per user, but you’d like to calculate the average events per project. This is possible, but you’d need to have Group Analytics for this. Here’s some documentation on Group Analytics: https://help.mixpanel.com/hc/en-us/articles/360025333632.
Here’s also a demo project that you can use to play around with Group Analytics: https://mixpanel.com/s/lZzFh
In this example, you can see that the average “Create Support Ticket” event per user is 1.2 when calculated at the user level, while at the company level, the average is 1.4.

Does that answer your question?