filter for timezone

[Shivang01]

I'm wanted to create a customized filter for our dashboard! The idea is to let users choose a timezone, like IST, PST, etc. We have a date column that's in UTC format, and using a dynamic date filter, I’m calculating some values. I’d love to set it up so that when users pick their preferred timezone, all the results will be computed in that timezone. 

[GavinW]

The below applies to Looker, rather than Looker Studio.

What you could perhaps do is use a paramterised time field to allow users to choose their timezone, and based on what they choose,  the logic of the field would update to add or subtract a certain number of hours from the field. You would have to write the SQL part to add or subtract the hours yourself, but it should be very straightforward to implement.

Just so you know, you can also set up Looker so that users can set their timezones themselves and apply them to date fields.