Timezones

Options
chrissy
chrissy Member
in Charting & Analyzer

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 Coach

    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