3 Replies Latest reply on Oct 23, 2013 10:59 AM by christinelam1

How to convert time zone in Tableau?

christinelam1 Oct 21, 2013 4:11 PM

If the timestamp values are stored in GMT, is there a way to convert GMT to another local time zone, taking into account daylight saving time (DST)?

I hope to build a flexible tool where the user could select their own local time zone in the dashboard. Please advise. Thanks.

1. Re: How to convert time zone in Tableau?

Alex Kerin Oct 21, 2013 8:26 PM (in response to christinelam1)

You would create a couple of parameters (time zone, observes DST) and a calc that takes all of this into account:

[date]+[timezone hours diff]/24 +if [DST] then 1/24 else 0 end

at the simplest.
Like Show 1 Likes(1)

Actions
2. Re: How to convert time zone in Tableau?

christinelam1 Oct 23, 2013 10:59 AM (in response to Alex Kerin)

How do I setup the [dst] field?
Like Show 0 Likes(0)

Actions
3. Re: How to convert time zone in Tableau?

Alex Kerin Oct 23, 2013 11:08 AM (in response to christinelam1)

http://kb.tableausoftware.com/articles/knowledgebase/using-parameters

You would probably set it up as an integer parameter with a value of 0 or 1 and then set its alias to ""No" and "yes"
Like Show 0 Likes(0)

Actions

Tableau Community Forums