To use the built-in Date Range filter at the top of the dashboard, write:
For example, New Users Per Day can be modified applying the dashboard-wide Date Range filter like so:
The daterange filter can be updated at the dashboard level, for example, to "90 days."
The filter parameters will then be applied to all charts using the daterange filter, such as "New Users Over Time."
The user can then re-enter the chart editor and click the Query tab to display the SQL showing the date restriction for the 90-day dashboard-level filter, complete with timezone correction:
To filter on only the start or end of the Date Range, write:
where my_datetime_column >= [daterange_start] where my_datetime_column < [daterange_end]
To create chart-specific date range filters that are independent of the dashboard-level filters, write:
Any number of days will work between the "=" sign and the word "days".
To filter date ranges to the current calendar week, month, or year, write:
where [my_datetime_column:wtd] where [my_datetime_column:mtd] where [my_datetime_column:ytd]
The built-in date range and aggregation filters syntax is similar.