👤 This documentation is intended for SQL Users.
To aggregate datetimes, use ":hour", ":date", ":week", etc.
select [created_at:date] from users;
select [created_at:week] from users;
select [created_at:month] from users;
To look at new users by week, the following SQL can be used:
Periscope supports the following date formatting options:
To specify the aggregation across the whole dashboard using a filter, the Aggregation Filter can be used.
select [integer_created_at:ts:date] from users
Learn more about Composing SQL Formatters.