4 Replies Latest reply on Nov 8, 2013 1:12 PM by Allan Walker

How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Ed Zanelli Nov 5, 2013 8:37 AM

I'm new to Tableau and geocoding. We manage marketing budgets by regions that include groups of countries. I'm trying to use a filled map visualization. Tableau recognizes many of the subregions that we use (e.g.: France, Italy, United States), but it doesn't recognize some others that are groups of countries (e.g.: Benelux, Nordics, UK and Ireland). I can right-click and Edit Locations; however, I can only choose one country to use as a matching location.

I have read about Allan Walker's crowdsourced WMS server; and, Richard Leeke's TabGeoHack. These seem like overkill for my situation. I wonder if anyone has solved a situation similar to mine and if so I would be very grateful for your advice and experience.

Thanks, Ed

1. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Allan Walker Nov 5, 2013 10:19 AM (in response to Ed Zanelli)
Ed,

Group the countries up as per your requirements.

Then join your data to the features file.

Best Regards,

Allan

Natural Earth Admin 0.zip 4.4 MB
Like Show 0 Likes(0)

Actions
2. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Ed Zanelli Nov 5, 2013 4:22 PM (in response to Allan Walker)

Hi Allan:

Thank you very much for your response! This is great stuff! I'm pretty sure this will meet all of my needs.

Thanks, Ed
Like Show 1 Likes(1)

Actions
3. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Ed Zanelli Nov 8, 2013 12:37 PM (in response to Ed Zanelli)

Hi Allan:

Many thanks for providing your map. It's obvious that there's a lot of work in there and I am very grateful that you were so willing to share it with me. I have a couple of questions that I wonder if you can help with.

Have you or anyone else tried to use the map with a Microsoft Analysis Services data connection in Tableau? The reason I ask is that when I join to this type of connection, the dimensions/attributes and measures are grayed out.

and;

We do separate budgets for Canada and French Canada (Quebec). Is there a way for me to differentiate these?

Thanks! Ed
Like Show 0 Likes(0)

Actions
4. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Allan Walker Nov 8, 2013 1:12 PM (in response to Ed Zanelli)

Ed,

Q1 no, but I've managed a PostgresSQL/ESRI personal dB data connection before. I believe there is an extension to Microsoft SQL sever (Spatial) that would possibly help you, but I don't want to lead you down the wrong path. Would advise using Postgres SQL/PostGIS, as these are spatially aware. The tables need to be Tableau ready format though:

I.e. ID,path order,X,Y

Q2 For the split between countries and provinces, you'll need to create a hierarchy using Natural Earth Admin 0 (the file I gave you) and Natural Earth Admin 1. You can append the tables, but I'd advise using NEA0 X,Y and NEA1 X,Y so you can join tables to both and use a dimension swapper between the two. Left outer on ID of the Feature (Shapefile DBF) PostGIS comes with a handy SHP loader.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

1. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

2. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

3. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

4. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)

Actions

More Like This

Incoming Links