Change the timezone in a question based on dropdown menu

Get Help
1

Hi,

I would like my users to dynamically change the timezone that is used in a Dashboard which contains multiple questions with a certain timezone.

Is there a way to do this without using Field filters?

If I cannot use field filters for this I would like to use the Text variable. I tried to add the variable in the WHERE clause like:
[[AND timezone = {{timezone}}]]
But then I got a 400 Bad Request POST error stating: "Unrecognized name: timezone at [9:72]", "reason" : "invalidQuery" } ]
Is there any way I can use the text variable in the SELECT statement of my query to be able to change the timezone based on this text?

Thank you!

2

Hi @Waffly
Have a look here on how to use Field Filters:
https://www.metabase.com/learn/sql-questions/field-filters

You'll need to have a lookup table with the timezones. It's not a session variable, if that is what you are trying to do.