Question

Timezone conversion for a specific dimension

  • 8 October 2021
  • 0 replies
  • 2 views

Hi,

 

My Database timezone is set to UTC. I use mysql. The database version is MySQL 5.7.

In one of the reports, I want the timezone to be considered as EST.

What I thought was to create separate dimension group “timestamp_EST” and add the timezone conversion in this dimension_group:

Example:

dimension_group: timestamp_EST {

type: time

timeframes: { [

     raw,
      time,
      minute,
      hour,

      date,
      week,
      month,
      quarter,
      year
    ]
    sql:  ${TABLE}.timestamp ;;
  }

 

But how do I add in timezone here?

Any kind of help is appreciated.

 

Thank you.


0 replies

Be the first to reply!

Reply