Example:
When I query the event "open drawing success", I want to know how many unique files a user opens.
We report "file Id" with every "open success" event, so in terms of handling the query - it's should be no problem to do AVG on count-distinct of unique file_id grouped by userId.
+2
Thanks for the idea!
While we are reviewing it I did want to bring up a workaround that could help. If you feel comfortable with JQL, you could groupBy your desired property (or properties) and then get a count of the property values.
Here is an example that would return a count of unique city property values for all events sent between 11/14 and 11/15:
function main() {
return Events({
from_date: '2018-11-14',
to_date: '2018-11-15'
})
.groupBy(["properties.$city"], mixpanel.reducer.count())
.reduce(mixpanel.reducer.count())
}
+4
This has been a basic need for us for quite some time! Answering questions around how many total pages, forms, buttons etc users are utilizing. Given how many properties we could use this for and the need to pivot data quickly to see trends over time vs cumulative totals doesn’t make JQL a easy scalable workaround but it is good to have that option.
+4
This 100% has to be included in Mixpanel....it's a common feature in many other analytics packages which is missing from MP.
Our use case is that we pass our unique user ID as an event property on every event and so we'd like to be able to run a query that allows us to quickly see how many unique users have conducted that event along with how many times that event has been triggered. The 'distinct ID' in MP does not work for us because we have multiple users on the same device/machine and hence the MP 'uniques count' sees 2 people on the same device as one person whereas we need to be able to see them as 2 people...hence an ability to count our own unique user ID by event would be fantastic.
I've voted...how quickly can you make this happen guys!?
Hi, has there been updates on this? It would be quite handy!
+4
If you haven't already, please make sure you are following this Idea - via the button in the upper right hand corner - to get emailed updates on its progress.
Hi all,
Any update on this one? We'd love to see this in the platform ASAP!
i.e. we pass a user_id as an event property and also pass an environment as an event_property (Dev, UAT, Prod etc...)....I'd like to count the number of unique user_ids within each environment.
At the moment I've got this, but this is giving me the unique number of user_ids across all envs...I'd like them split by the environment.
function main() {
return Events({
from_date: '2019-08-27',
to_date: '2019-09-21'
})
.groupBy(["properties.$user_id"], mixpanel.reducer.count())
.reduce(mixpanel.reducer.count())
}Thanks,
Tom
I think this idea is similar if not identical to https://community.mixpanel.com/submit-an-idea-15/unique-count-over-aggregation-in-insights-report-3546
...in development for 1 month now. Fingers crossed
+1
Hello
More details in this thread: https://community.mixpanel.com/announcements-6/insights-report-new-changes-coming-comment-to-get-access-to-beta-4205
If you’d like to get access to this, 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.