Composing SQL Formatters
👤 This documentation is intended for SQL Users.
SQL Formatters can be chained together, one after another. For example, to convert a timestamp to Pacific Time and then aggregate by date, query:
select [created_at:pst:date] from users.
Combining this with automatic joins allows for quick, powerful queries such as:
select [users.created_at:pst:date], users.platform, sum(price)
from [purchases+users]
group by 1, 2
In Sisense for Cloud Data Teams, this displays revenue by user platform:
![](https://cdn.prod.website-files.com/58fe8f93dc9e750ca84ebb16/5bfee356343a30d10d9797ab_SQL%20Formatters.png)
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form