Visual Insights: Using the date range filter

Follow
Available for User roles Super Admin, Admin, Team Member, Limited Team Member
Packages All packages

One of the most frequently used filters on Visual Insights dashboards is the data range filter. Most charts on Visual Insights dashboards are affected by the date range filter, which defines the time frame within which data is measured. The date range filter is highly configurable in order to allow you to search within dates from a wide range of relative and absolute time frames. This article will walk you through how the filter measures time when a date range is input.

Accessing the date range filter

The date range filter can be found in the upper-left of the filter bar above most Visual Insights dashboards. Once the filter has been expanded, you can select an operator (e.g. "is in the last," "is in range") and select/input a specific range (e.g. 30 days, 6 months, etc.) Dates in the date range filter are set to Coordinated Universal Time (UTC) and formatted as [YYYY]/[MM]/[DD]. To learn which dashboards can be filtered by date range, as well how filtering works in general, refer to our dashboard filters help article

Date range filter expanded on Visual Insights dashboard

Date range functions

Below you will find a breakdown of how the time frame is calculated for each of the configurable date range functions available in the filter. Each row in the table corresponds to an example of how a date range function would define a time frame based on the possible operator/range pairings. Scroll within the table to read the full list of pairings and their corresponding functions. When reading the table, consider 2022/06/15 as the current date unless otherwise stated.

Date range filter input Function
Operator Range Start Date End Date Description
is in the last 30 days 2022/05/17 2022/06/16 Adds 1 day to current date and then looks back 30 days.
4 weeks 2022/05/23 2022/06/20 Looks at the last day of the current week, adds 1 day, and then looks back 4 weeks.
3 months 2022/04/01 2022/07/01 Looks at the last day of the current month, adds 1 day, and then looks back 3 months.
2 quarters 2022/01/01 2022/07/01 Looks at the last day of the current (calendar) quarter, adds 1 day, and then looks back 6 months.
1 year 2022/01/01 2023/01/01 Looks at the last day of the current year, adds 1 day, and then looks back 1 year.
6 complete weeks 2022/05/02 2022/06/13 Looks at the last day of the previous week, adds 1 day, and then looks back 6 weeks.
is on the day 2022/06/15 2022/06/15 2022/06/16 Adds 1 day and then looks back 1 day.
is in the range 2022/02/01 until 2022/06/15 2022/02/01 2022/06/15 Since this function looks between two exact dates, we recommend using this operator for the most accurate filtering.
is before (relative) 2 months ago 1970/01/01 2022/04/01 Looks at the first day of the current month, subtracts 2 months, and then looks back to the first day of 1970.
is before (absolute) 2022/06/15 1970/01/01 2022/06/14 Looks at the day preceding the input date and then looks back to the first day of 1970.
is on or after (relative) 2 months ago 2022/04/01 2022/06/16 Looks at the first day of the current month, subtracts 2 months, and then looks forward to the current date plus 1 day.
is in the year 2022 2022/01/01 2023/01/01 Looks at the first day of the input year and then looks forward 1 year.
is in the month June 2022 2022/06/01 2022/07/01 Looks at the first day of the input month (of the selected year) and then looks forward 1 month.
is this day 2022/06/15 2022/06/15 Adds 1 day and then looks back 1 day.
week 2022/06/13 2022/06/20 Looks at the last day of the current week, adds 1 day, and then looks back to the first day of the week.
month 2022/06/01 2022/07/01 Looks at the last day of the current month, adds 1 day, and then looks back to the first day of the month.
quarter 2022/04/01 2022/07/01 Looks at the last day of the current (calendar) quarter, adds 1 day, and then looks back 3 months.
year 2022/01/01 2023/01/01 Looks at the last day of the current year, adds 1 day, and then looks back 1 year.
is next day 2022/06/16 2022/06/16 Looks at the end of the current day and then looks forward 1 day.
week 2022/06/20 2022/06/27 Looks at the last day of the current week, adds 1 day, and then looks forward 7 days.
month 2022/07/01 2022/08/01 Looks at the last day of the current month, adds 1 day, and then looks forward 1 month.
quarter 2022/07/01 2022/10/01 Looks at the last day of the current (calendar) quarter, adds 1 day, and then looks forward 3 months.
year 2023/01/01 2024/01/01 Looks at the last day of the current year, adds 1 day, and then looks forward 1 year.
is previous day 2022/06/14 2022/06/14 Looks at the end of the previous day and then looks back 1 day.
week 2022/06/06 2022/06/13 Looks at the last day of the previous week, adds 1 day, and then looks back 7 days.
month 2022/05/01 2022/06/01 Looks at the last day of the previous month, adds 1 day, and then looks back 1 month.
quarter 2022/01/01 2022/04/01 Looks at the last day of the previous (calendar) quarter, adds 1 day, and then looks back 3 months.
year 2021/01/01 2022/01/01 Looks at the last day of the previous year, adds 1 day, and then looks back 1 year.
is 4 weeks ago for 9 weeks 2022/05/16 2022/07/18 Looks back 4 weeks, adds 1 day, and then looks forward for the next 9 weeks.
3 months ago for 5 weeks 2022/03/01 2022/04/01 Looks at the first day of the current month, looks back 3 months, and then looks forward for the next 5 weeks.
is null N/A N/A N/A Date is null; results may not be returned.
is any time N/A N/A N/A Looks at the data set throughout all time; may cause long load times.
is not null N/A N/A N/A Looks at the data set throughout all time; may cause long load times.
matches N/A N/A N/A Uses advanced filtering logic; recommended only for advanced users. For more, refer to Looker's filter expression documentation.
Was this article helpful?
0 out of 0 found this helpful