Date and Time Selector

Determine the time range of a query by clicking on the time selector. The time selector is common across all reports. This article details the options in the time selector.

All dates and times in Mixpanel reflect the project timezone.

Click on Last 30 days at the top of the report breakdown to access the following options:

Screen_Shot_2020-08-31_at_3.38.51_PM.png

The default on most reports is “Last 30 days”, but there are a variety of pre-set options, as well as the option to select a custom date range.

For these date ranges, the output shows results from the last complete 30 days, plus any results from the current incomplete day. 

Current day

Current incomplete day up to the current second.

Previous day

Last complete 24 hour period and the query count from the current incomplete day up to the current second.

In Insights Previous day only includes the last complete 24 hour period.

Last 30 days

Last 30 days and the query count from the current incomplete day up to the current second.

Last 3 months

Last 3 months and the query count from the current incomplete day up to the current second. 

Last 6 months

Last 6 months and the query count from the current incomplete day up to the current second. 

Last 12 months

Last 12 months and the query count from the current incomplete day up to the current second.


Select a Date Range

The Select date range menu opens up some additional options, "Last", "Fixed" and "Since".

Last

“In the last” allows you to select a rolling time range similar to the default “last 30 days” but you have the flexibility to choose the time value and scale, either days, weeks, or months.

Screen_Shot_2020-08-31_at_3.45.05_PM.png

If you need to, you can click on the + Ending button and shift back the desired time window by a selected amount of days. So for instance in the example below, we are still looking at a 2-week window that is shifted by 7 days back. This is a rolling date range and if this report is saved as a bookmark or added to a dashboard the actual dates will continue to update to show this relative time period vs. Today.

Screen_Shot_2020-08-31_at_3.46.20_PM.png

Fixed

“Fixed” allows you to select two dates to query between or a select particular day to query by entering the same start & end date. If you save this report as a bookmark or add it to the dashboard, the date range selection will always persist.

Screen_Shot_2020-08-31_at_3.40.40_PM.png

Since

“Since” allows you to select a specific date to query for all data since that start date.

Cohorts, Explore, Messages and Experiments

In addition to the Select date range menu options available in Analysis, the "in the next" option is available for Cohorts, Explore, Messages, and Experiments when you select a date property

In the Next

"In the next" allows you to select a time range similar to the default "next 30 days" but you have the flexibility to choose the time value and scale, ranging from hours to days, weeks, or months. 

 

Did this answer your question?

Comments

0 comments

Article is closed for comments.