I would like to be able to count unique values for aggregates of an event property. Currently if I select Unique and an aggregate, the graph still shows the Unique user counts, see screenshots below:
Unique over product id, I expected to see number of different values for Product id booked. However these are the same numbers as below, which is just unique users doing Product booked:
+4
I am not sure if I am understanding your Idea completely. It sounds like you would like to have the unique count of Product Viewed event, and add up the value (aggregate) the number of times the Product ID property for all of the times this event happened in the selected time range?
Taking a step back, our aggregation feature will add up the value of the event property for all of the times this event happened in the selected time range. This means that it will have to use the SUM data function(or other available data functions).
+2
Hi
+4
This makes total sense. I was wondering why there is only sum, avg, etc. and not a Total / Distinct function available when I choose aggregate by event attribute.
Please, go for it ;)
BR, Carsten
Any news on this? Facing a similar problem and unable to proceed 
+4
If you are not automatically subscribed to this Idea, please make sure you do by clicking on the subscribe star button - at the bottom of the original idea post - to get emailed updates on its progress.
I’ll be here!
Hey
I think I have a similar problem where, in our product we have multiple user_ids against an account_id, and we often want to know how many accounts have experienced Event ‘X’. We pass the account_id of our users into the event properties of all our events, and we want to be able to not only count the unique User_IDs against Event ‘X’, but also the unique Account_IDs against Event ‘X’. Will the new ‘unique count’ feature enable me to calculate this? Is there a way we can calculate this right now?
We currently can’t find a way to do this in Mixpanel and getting this capability is going to be critical to whether or not the team can get any value out of the tool, as we’re currently forced to load the data to Snowflake & then Looker.
If it will fix this, are there any updates on how the unique aggregation build is progressing?
Thanks,
Tom
+2
Hello
Quick update: Distinct property values across all events is still being built, but “Distinct property values on a per-user basis” is already supported in this beta (https://community.mixpanel.com/announcements-6/insights-report-new-changes-coming-comment-to-get-access-to-beta-4205), and here’s the difference between the two:
Let’s consider this example of users watching videos (with a videoID), where we want to analyze how many unique videos are being watched:
Distinct property value count per-user (VideoID) for User1: (A,B) → 2 ,
Distinct property value count per-user (VideoID) for User 2: (A,B,C, D, E) → 5
Distinct property value count per-user (VideoID) for User 3: (X, Y, Z, A, B) → 5
Distinct property values across all events: (A,B,C,D,E,X,Y,Z) → 8
If you’d like to get access to the beta, please send us an email on insights@mixpanel.com and we can set your projects up!
Moinak
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
