The easiest way to do this would be to take the [Data Updated Time] field that is currently in the server time zone, and create a new calculated field that calculates your local time zone based on that.
For example, if your local time zone is 6 hours ahead of the server time you could create a field like this:
dateadd(,'hour',6,[Data Updated Time])
Just switch out the "6" with however many hours your time zone is ahead, or with a negative number if you're behind the server time zone.
Let me know if you have any questions.
DATEADD works well for timezone conversion but you can't use the built-in Tableau <Data Update Time> field in a calculation, not even parsing it as a string. You could add a text note in the caption next to <Data Update Time> resulting in something like 12:49PM PT (+3 hours for ET)
Or if the data your are extracting is itself the result of an export or an ETL process you may be able to get that timestamp inserted into the data. Then convert that to your local timezone. It's even more accurate that way.
Thanks for that;) Should have tested my proposed approach for publishing it here.
Have a nice one.
Thanks for the suggestions, I got a good challenge here.
The users are from different time zone, need some way to gets the user's local time zone as parameter and do the conversion on the fly.