Dashboards
Dashboard Filtering Options
Custom and Relative Date Ranges with Time Units
9 min
you can use the date picker to filter dashboards and widgets by time the date picker supports both predefined ranges and custom date input this article explains how to use each option and provides a reference for creating custom time expressions use quick date ranges the date picker includes a list of predefined ranges, also known as presets these options allow you to apply common time filters quickly, without manually entering dates when you select a quick range the start and end fields are filled automatically the date range label updates to reflect your selection the filter is applied when you select apply available quick ranges the following quick ranges are available quick range start end start (example) end (example) last 15 minutes now 15m now 15 minutes ago current time last 30 minutes now 30m now 30 minutes ago current time last 1 hour now 1h now 1 hour ago current time last 5 hours now 5h now 5 hours ago current time last 10 hours now 10h now 10 hours ago current time last 24 hours now 24h now 24 hours ago current time today so far now/d now today at 12 00 am current time today now/d now/d today at 12 00 am today at 11 59 pm yesterday now 1d/d now 1d/d yesterday at 12 00 am yesterday at 11 59 pm last 2 days now 2d now 2 days ago current time last 3 days now 3d now 3 days ago current time last 7 days now 7d now 7 days ago current time this week now/w now/w sunday at 12 00 am saturday at 11 59 pm this week so far now/w now sunday at 12 00 am current time last week now 1w/w now 1w/w previous sunday at 12 00 am previous saturday 11 59 pm this month now/m now/m first day of the month last day of the month this month so far now/m now first day of the month current time last month now 1m/m now 1m/m first day of last month last day of last month this quarter now/q now/q first day of the quarter last day of the quarter this quarter so far now/q now first day of the quarter current time last quarter now 1q/q now 1q/q first day of last quarter last day of last quarter this year now/y now/y january 1 december 31 this year so far now/y now january 1 current time note the calendar week starts on sunday all ranges are calculated in your local time zone unless otherwise configured use custom date ranges you can enter custom values in the start and end fields to define a date range that isn't covered by the quick presets enter a range manually you can select a range in two ways use the calendar icon to pick specific dates from a calendar view type a relative time expression (such as now 3d) into the start and end fields understand relative time expressions relative time expressions let you filter data based on the current time use the word now as a reference point, followed by a time offset such as 3d (three days ago) supported time units m — minutes h — hours d — days w — weeks m — months q — quarters y — years syntax options expression result now current time now 7d 7 days ago now+3d 3 days in the future now/m start of the current month now 1q/q start of last quarter now/y start of the current year now 2w to now 1w a custom range from 2 weeks ago to 1 week ago use / to round to the start of a time unit now/d = start of the day now/w = start of the week now/m = start of the month now/y = start of the year fix invalid input if your custom input is invalid an error message appears below the input field the apply button is disabled you must correct the error before applying the filter examples of invalid input typing now three instead of now 3d leaving one of the fields empty entering a start date that is after the end date