Articles | C2C

UTC to User Time Zone in Google Data Studio | GSuite Solved

Written by Manish bhattarai | Sep 28, 2022 5:00:00 AM

Hi All,

I have a bigquery table which stores data from Firestore. Firestore stores all the timestamps in UTC timezone. Is there a best practice how I can display those timestamps in user timezone (not in UTC timezone) in Google Data Studio Dashboards?

I would like to avoid converting the timestamp adding another field such as CreatedDateNY (using DateDiff).  

 

Best answer by ilias

you can try the following steps:

  • click on the ADD A FIELD, right down corner on Data Studio,
  • use Formula: DATETIME_SUB(Order Received, Interval 2 HOUR), you can have your time difference from UTC here
  • click SAVE
  • click FINISHED
  • move it from the Available Fields to the Dimension
View full post