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.