Aggregation Filter

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

The dashboard-wide "Aggregation" filter can be applied using:

select [my_datetime_column:aggregation]

For example, here's a query that tracks new users over time, using an interval that's defined at the dashboard level:

The aggregation filter can be updated at the dashboard level, for example, to "Weekly."

The resulting chart displays the data with "Weekly" aggregation applied.

Users can re-enter the chart editor and view the resulting SQL by selecting the "Query" tab:

To aggregate date ranges independent of the dashboard-wide filter, check out the Date Aggregation SQL formatter.

Looking for More?

Try our community page for guidance on topics like:

Our support team is ready to help