👤 This documentation is intended for SQL Users.
Use ":day_of_month", ":hour_of_day", etc. to convert dates and times to the appropriate date part. For example ":day_of_month" might return "22" and ":hour_of_day" might return "8".
Let's plot purchases by day of week:
Periscope supports the following date-part extractions:
:day_of_week (or :dow)
:day_of_year (or :doy)
Use ":ts" to convert epoch or unix timestamps to a readable "YYYY-MM-DD HH:MI:SS" format. This can then be used with the above date part and date aggregation shortcuts.