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:

<body>
     <blockquote>
       <br>:sec
       <br>:min
       <br>:hour
       <br>:day
       <br>:date
       <br>:week
       <br>:month
       <br>:year
      </blockquote>
  </body>

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