Chart date picker
The date picker selects the timeframe of the analysis you're running. You can analyze data collected between two dates, since a specific date, or in the last x days, weeks, or months.
The date picker has nuances in how it handles time. This page covers each one.
The datepicker selects the timeframe of the analysis you're conducting. You can choose to analyze data collected between two dates, since a specific date, or in the last x days, weeks, or months.
The datepicker has nuances in how it handles time.
Offset
When you use Last, your queries return data from the specified timeframe, plus the latest still-incomplete interval.
For example, when you set the datepicker to the last 30 days, Amplitude retrieves data from the last 30 full days, plus the hours elapsed today.
To exclude data from the incomplete day, or when you use a delayed batch ingestion system, use an offset. Click +Offset in the datepicker, then enter the number of days to offset by.
To remove the offset, click 'X' near the Offset by text.
Exclude
When you use Since or the Last x days, weeks, or months options, you can also exclude the current day, week, or month. This helps when the data for the selected timeframe isn't fully available.
To exclude the incomplete time interval from your chart, click +Exclude in the datepicker and select the Incomplete Interval option. The current date no longer appears framed in a dotted line, and Amplitude excludes it from your analysis.
Deselect Incomplete Interval to revert this setting. Use the same process to exclude or include the current week, current month, or current quarter.
Amplitude doesn't support using offset and exclude at the same time.
Exclude specific days
You can exclude specific days of the week from your analysis. This option suits organizations that operate on custom schedules. For example, retailers can exclude Sundays when stores aren't open, or SaaS companies can omit weekends to focus on workweek behavior.
Excluding specific days affects both chart visuals and metric calculations like averages and rolling windows.
Exclude specific days supports only the following chart types:
- Segmentation.
- Funnels.
- Data Tables.
- Retention.
- Sessions.
Exclude specific days supports only the following time ranges:
- Last.
- Since.
Exclude specific days doesn't work with Period over Period analysis, and it doesn't work with realtime intervals.
How Amplitude handles excluded days
When you exclude days, Amplitude:
- Removes the days from the calculations and from the chart visualization.
- For averages, calculates on the valid days in the window. For example, if you're looking at the range Sunday - Saturday (7 days) with Wednesday removed:
- For non-average time series analysis, the data shows as normal with Wednesday removed.
- For aggregate data analysis, the data doesn't count the Wednesday in the aggregation.
- For averaging analysis (such as the rolling window), Amplitude doesn't count the dropped days in the numerator or the denominator. If you have a 7-day rolling window, Amplitude treats the data point as a 0 and divides the average based on the valid days in the window (6 days in this example).
- For non-daily or non-hourly intervals analysis, Amplitude doesn't remove data from the chart or the table. However, the data still has the underlying days removed.
This method avoids artificially low averages and maintains consistent windowing on charts.
Time input
When you use Since or Between, you can narrow the range further by enabling time input. Time input lets you enter a start time or an end time to add granularity to your analysis.
The datepicker's time input feature is only available for Event Segmentation and Funnel Analysis charts.
To enable time granularity, click +Time in the datepicker. After you enable time input, enter the start or end times in hours, minutes, and seconds to accompany your selected date range.
To turn off time input, click the 'X' near the entered time.
Presets
The datepicker also supports presets to streamline repetitive analysis and ensure consistency across teams.
Using presets
Presets give you quick access to predefined time ranges, including:
- Last 7 days.
- Last month.
- Year to date.
- Custom fiscal periods.
When you select a preset, the datepicker automatically fills in the associated time range.
Custom presets
You can create custom presets for recurring analysis windows like product launches, campaigns, or testing periods. Presets can include:
- Specific start/end dates.
- Relative timeframes (for example, "Last 60 days").
- Optional exclusions (like incomplete data or specific weekdays).
Amplitude defines presets at the project level, and they're available across the project. Admins and managers can create, edit, and manage these presets in Project Settings.
Default presets
Users can also define their own default preset for a given project. This preset automatically applies when creating new charts.
Was this helpful?
For AI agents: a documentation index is available at /docs/llms.txt. Append .md to any page URL for markdown, or send Accept: text/markdown.