The IANA timezone database might be worth a look. I haven't actually used it before, but I think it would contain the information you need, pending some formatting to get it Tableau readable.
Your indications are rigth, but there I only can download the data in Linux and I do not know to work with it.
Thank you very much,
Oh! Allan, it is very good job.
Now, I am trying to use it with my dataset, may I?
It is a little bit difficult, or perhaps as easy as I can not see it. What do you recommended me?
Find attached my workbook. My first sheet is a Map where I would like to select a Time Zone to filter my other sheets by it.
If I can do it, I sitl will need to extract the city to my DWH to do the work well done. But rigth now, if I can include the Time Zones to the map in order to select one I will we very happy.
Can you help me? How I do proceed now?
Thank very much,
Can you post your packaged workbook?
Here's a rough version, using Allan's timezone data and your Excel data. The trick is to add both data sources to your workbook, then blend them using a common field. Here, I looked at adding a CountryName field to your Excel file, to line up with 'name' in Allan's data. But it was easier to create a calculated field on his datasource to get a number and call it 'Hour UTC'.
Once you have a common field (either named the same or set up via Data --> Edit Relationships), you can use fields from the second/blended data source for coloring or filtering.
I hope this example helps. There are other approaches (e.g., import the time zone data into your DWH, then connect with Tableau Desktop and join the data tables with a Multiple Tables or Custom SQL data connection), but this should give you something to work with.
Best of luck,
My Data 2.twbx 1.3 MB
Thank you very much. It is very close to the solution I would like,
As you say, I have to found the way to make a relationship between the two tables, and I think it is not as easy as you comment.
I have to work around a little more time. But you give me the way.