Will the report be opened in Tableau Desktop or on an instance of Tableau Server?
Will the report be connected to a live data source or an extract?
1 of 1 people found this helpful
You have a couple of problems here;
1. Getting the timezone of the current user / client
2. Converting the data to the timezone from (1)
Getting the timezone of the current user / client
- If you're doing this at client level it would be a bit easier. In other words, if you can assume that a client all use the same timezone, you could set a UTC offset at the client level and store this in the database in a table or in the Tableau report as a parameter or calculated field
Converting the data to the target timezone
- Once you have an offset for the timezone you can use the DATEADD function in Tableau to convert or the dateadd function in your database. Taking into account daylight savings is tricky, and you should do some reading on how to do that within SQL. In MSSQL you might be able to utilize something like TODATETIMEOFFSET
TLDR: There is no native support for such a conversion inside Tableau, nor is there native support to detect the client timezone.
I really appreciated your attention.
I'll do some research about it, but thanks to give me a way to go.