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
