Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Time Zone in Data Studio Reports

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

We've got a set of reports that pull from BigQuery, where the date fields are stored as TIMESTAMP values in UTC.

 

After reading the documentation and a few other threads, it said Data Studio expects the times in the data source to be UTC, so I think we've done right here.

 

How can we change the times in our report to reflect our time zone for the end users? We are in the UK, so it's BST at the moment, UTC+1.

 

I've checked in the Google Admin console and the time zone for all our accounts is set to Europe/London.

 

Regards,

Samuel Melrose

Time Zone in Data Studio Reports

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I have a same situation as we use Big Query, but our time zone is GMT+7. We have to manually add more 7 hours to all date_time value. Is there any better way to treat the UTC Date Time to be display in our timezone? The date filter should work with the local timezone too.

Time Zone in Data Studio Reports

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hello Truc,

 

We ended up using a Standard SQL view (via Custom Query in Data Studio, "SELECT * FROM view", untick "Use Legacy SQL").

 

Then in BigQuery, all our date/time fields were timestamps, so we convert them to DATETIMES at our timezone, e.g.

   DATETIME(createdAt, 'Europe/London')

And it will handle all of the time zone stuff like daylight savings.

 

This worked for us as we are doing other data processing that requires a view anyway, but you do lose the ability for Data Studio to restrict query size based on date partition when using one (see my issue tracker issue https://issuetracker.google.com/issues/63319132)

 

You might also want to help support better Standard SQL support: https://issuetracker.google.com/issues/63319049

 

Regards,

Samuel Melrose