Calculating Unique User Sign-Ins Over a Specified Timeframe

·Feb 28, 2025 01:31 PM·

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

➕1

🎫1

1 comment

· Sorted by Oldest

Thena
APP
·
·
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: Inline Attachment: image.png Which, in the Bar chart format, will look like this: Inline Attachment: image.png Please note that the Custom Bucketing on this report is what allows for the single day grouping: Inline Attachment: image.png You can access this setting by clicking the '...' overflow menu on the event metric: Inline Attachment: image.png 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 MarinoffSupport Engineer II --------------------💬 Liked my support? Please share your feedback in the survey you'll receive soon.

Thena
APP
·
·
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: Inline Attachment: image.png Which, in the Bar chart format, will look like this: Inline Attachment: image.png Please note that the Custom Bucketing on this report is what allows for the single day grouping: Inline Attachment: image.png You can access this setting by clicking the '...' overflow menu on the event metric: Inline Attachment: image.png 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 MarinoffSupport Engineer II --------------------💬 Liked my support? Please share your feedback in the survey you'll receive soon.