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