This article will help you:
- Understand nuances in the way the datepicker understands time
In Amplitude, you use the datepicker to select the timeframe of the analysis you're conducting. In many ways, it's very intuitive, as it's something you've most likely seen in other software contexts. You can choose to analyze data collected between two dates, since a specific date, or in the last x days, weeks, or months, where x is a value you select.
However, there are certain nuances to the way the datepicker understands time. This explainer should clarify these nuances for you.
Offset
When using Last, your queries will return the data from the timeframe you specified, as well as the latest, still-incomplete interval.
For example, if you set the datepicker to the last 30 days, you'll get data from the last 30 full days, and data from however many hours have elapsed today.
The dotted line that's framing March 13th tells you that the data for that day is incomplete. (Similarly, you'd see this data represented on a chart as a dotted line.)
If you'd rather not get data from the incomplete day, you can use an offset. To use an offset, click Add Offset from the Advanced Settings dropdown. Then enter the number of days to offset by.
Using the example from above, set the datepicker to collect data from the last 30 days, offset by one. The current date, March 13th, would no longer be surrounded by a dotted line because it would be excluded from your analysis.
To remove the offset, click Remove Offset from the Advanced Settings dropdown.
Exclude
When using Since or the Last x days, weeks, or months options, you can also choose to exclude the current day, week, or month. This can be helpful when the entirety of data for the selected timeframe is not yet available.
To exclude the current day, click Exclude Today from the Advanced Settings dropdown. The current date (March 13th) would no longer be framed in a dotted line and would be excluded from your analysis.
You can change this at anytime by clicking Include Today. Use the same process to exclude or include the current week or current month in the datepicker.
NOTE: The offset and exclude functionalities cannot be used simultaneously.
Time input
When using Since or Between, you can narrow down your selected time frame even further by enabling time input. Time input allows you to enter a start time or an end time to add granularity to your analysis.
NOTE: The datepicker's time input feature is only available for Event Segmentation and Funnel Analysis charts.
To enable time granularity, click Enable Time Input from the Advanced Settings dropdown. Once enabled, enter the desired start or end times in hours, minutes, and seconds to accompany your selected date range.
To turn it off, choose Disable Time Input from Advanced Settings.