The dashboard-wide "Aggregation" filter can be applied using:
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.