UTC to User timezone in Google Data Studio | C2C Community
Question

UTC to User timezone in Google Data Studio

  • 24 January 2022
  • 2 replies
  • 213 views

Userlevel 1

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).  

 

regards,

Manish


2 replies

Userlevel 7
Badge +56

Hi @parentiv,

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

Okay, thanks

Reply