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:

Sisense 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.