Understanding 1 day Filtering in Event Reports
In reports, I can filter events by "Time > 1 day". Is "1 day" a 24 hour period, or is it the time separated by midnight GMT, or something else?
In reports, I can filter events by "Time > 1 day". Is "1 day" a 24 hour period, or is it the time separated by midnight GMT, or something else?
Hi Philip, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đ
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
In Mixpanel reports, when you filter events by "Time > 1 day," the definition of "1 day" is based on your project's timezone, not strictly a 24-hour period from the current time or midnight GMT. All dates and times in Mixpanel reflect the project timezone you have set. For example, "Yesterday" includes the whole of the previous day from midnight to midnight in your project timezone, and similar logic applies to other date-based filters and breakdowns. This means "1 day" refers to a calendar day as defined by your project settings, not a rolling 24-hour window or GMT midnight boundary Reports Overview â Date Range.If you need to change the timezone, you can do so in your project settings, and this will affect how all date and time filters are applied in your reports Managing Project Timezones.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšď¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai My project's timezone is Asia/Taiwan. I have an event that took place at 10am July 10 Asia/Taiwan time. At 12pm July 11 Asia/Taiwan time filtering by time/1 day still shows you event. The following day (July 12) the event finally is filtered out. Explain to me why it works this way
Let me check the knowledge base for you again. One moment! đ
The behavior youâre seeing is because Mixpanelâs date and time filters in reports are based on your projectâs timezone and use calendar days, not rolling 24-hour periods. In your case, with the project timezone set to Asia/Taiwan, â1 dayâ means a full calendar day from midnight to midnight in Asia/Taiwan time.So, if your event happened at 10am on July 10 (Asia/Taiwan time), it will be included in the âlast 1 dayâ filter until the end of July 11 (23:59:59 Asia/Taiwan time). On July 12, the event falls outside the most recent full calendar day and is no longer shown when filtering by âTime > 1 day.âThis is confirmed in Mixpanelâs documentation: âAll dates and times in Mixpanel reflect the project timezone. The default on most reports is âLast 30 daysâ (displayed as â30Dâ), but there are a variety of pre-set options, as well as the option to select a custom date range.â The âYesterdayâ preset, for example, is defined as âthe whole of the previous day from midnight to midnightâ in your project timezone Reports Overview â Date Range.So, Mixpanelâs â1 dayâ filter is not a rolling 24-hour window, but rather a calendar day as defined by your projectâs timezone setting.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšď¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
If an event occurs at 00:01 Asia/Taipei time will it remain relevant (to the 1 day filter) for 48 hours
Let me check the knowledge base for you again. One moment! đ
If an event occurs at 00:01 Asia/Taipei time, it will remain relevant to the "1 day" filter until the end of the next calendar day in your project timezone. In Mixpanel, "1 day" refers to a full calendar day (midnight to midnight) in the project timezone, not a rolling 24-hour period.So, for an event at 00:01 on July 10 (Asia/Taipei time): - On July 10, the "last 1 day" filter includes all events from 00:00 to 23:59:59 on July 10. - On July 11, the "last 1 day" filter includes all events from 00:00 to 23:59:59 on July 11.The event at 00:01 on July 10 will only be included in the "last 1 day" filter on July 10. By July 11, it will no longer be included, because the filter now only includes events from July 11. Therefore, the event will not remain relevant for 48 hours; it will be relevant for less than 24 hours, specifically until the end of July 10 in your project timezone.This behavior is based on Mixpanel's use of calendar days for date filters, as described in the documentation: "All dates and times in Mixpanel reflect the project timezone... For these date ranges, the output shows results from the last complete 30 days, plus any results from the current incomplete day"Â Reports Overview â Date Range.If you are seeing different behavior, such as the event remaining in the filter for 48 hours, it may be due to a misunderstanding of the filter or a specific configuration, but the documentation does not indicate that "1 day" filters should work this way.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšď¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.