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:
![](https://cdn.prod.website-files.com/58fe8f93dc9e750ca84ebb16/5c006e51a8e61a0214d982da_Date%20Aggregation.png)
Sisense 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.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form