Date Aggregation

👤 This documentation is intended for SQL Users. 

To aggregate datetimes, use ":hour", ":date", ":week", etc.

For example:

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:

:sec

:min

:hour

:day

:date

:month

:year

To specify the aggregation across the whole dashboard using a filter, the Aggregation Filter can be used.

Date

select [integer_created_at:ts:date] from users

Learn more about Composing SQL Formatters.

Our support team is ready to help