Timezones

chrissy
chrissy ⚪️
in Charting

Is there a way to convert timezones for certain graphs within beast modes? I am looking at online activity for different clients within different timezones ( the metric is 'appt_created_time_utc') and cannot figure out how to adjust each graph to reflect their specific timezones.

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    You can use the CONVERT_TZ function to convert one timezone to another. You just pass in the field you're wanting to convert, the timezone the data is in and then the timezone you wish to convert to.


    CONVERT_TZ(`Timestamp`, 'UTC', 'US/Central')
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories