Hi, I'm trying to figure out how to calculate the number of days a user has done an event over the last x days. To give one example: over the last 30 days, how many unique days have a user signed in to the application
Hi Marius, My name's Scott and I'm a Support Engineer at Mixpanel. Thanks for writing in — happy to help. Jumping right to it, you can get to that answer using the 'Aggregate Property per User' function with a Distribution measurement, like this:
Which, in the Bar chart format, will look like this:
Please note that the Custom Bucketing on this report is what allows for the single day grouping:
You can access this setting by clicking the '...' overflow menu on the event metric:
Does that get you to the answer you were after, Marius? Please let me know if I missed the mark, or if there's anything else I can assist with. Sincerely,
Scott Marinoff
💬 Liked my support? Please share your feedback in the survey you'll receive soon.
