<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=2634489&amp;fmt=gif">

Google Workspace, Data Analytics

UTC to User timezone in Google Data Studio

By Manish bhattarai | September 28, 2022

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

Recent Articles

Google Cloud Strategy

AI Cheat Sheet

AI is no more and no less the drive to create robots with human minds so they can do everything we do and more. Use this cheat sheet to help decode the space.
By Leah Zitter
AI and Machine Learning

CarCast with Bruno Aziza: What Makes Us Better Than AI?!

Unlock the secrets of human cognitive superiority over AI in this compelling CarCast with Bruno Aziza and Kenneth Cukier.
By Bruno Aziza
AI and Machine Learning

CarCast with Bruno Aziza: The Metrics You CAN'T Afford To ...

Discover essential CEO metrics: Rule of 40, CAC Ratio, NRR/GRR, and more. Optimize your business for success now!
By Bruno Aziza