Date Range Filters

👤 This documentation outlines how to apply the default date range filter into Periscope charts, and is intended for SQL Users. View Only Users can select values within the date range filter to update the timeframes displayed in any charts where the filter is implemented.

Dashboard-Level Date Range

To use the built-in Date Range filter at the top of the dashboard, write:

where [my_datetime_column=daterange]

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]

Timezone Conversions

To remove any backend timezone conversions that convert timestamps without timezones to your site timezone, write:

where [my_datetime_column=daterange_no_tz] 

More detail on the timezone conversions in Periscope, refer to the documentation here.

Ad-Hoc Date Ranges

To create chart-specific date range filters that are independent of the dashboard-level filters, write:

where [my_datetime_column=30days]

Any number of days will work between the "=" sign and the word "days".

Yesterday, Week-To-Date, Month-To-Date and Year-To-Date

To filter date ranges to yesterday or the current calendar week, month, or year, write:

where [my_datetime_column:wtd]

where [my_datetime_column:mtd]

The built-in date range and aggregation filters syntax are similar.

Looking for More?

Try our community page for guidance on topics like: 

Our support team is ready to help