Hi Christian, are you looking for a filled map? Or a map with say different sized/colored circles to show your data? Ones easy, the other is hard.
ideally we could fill the countries/regions. if this is not possible we could use a bar chart as well, that are placed in the geographic center of the region...
Christian, got it. Let me work out some options for you. But it will be later today. (I hate it when my real job gets in the way of my play!)
Thanks, Shawn. greatly appreciated!
to give you a bit more background on the data format, here is a screenshot of how the table looks like (it's a mix of bigger countries and regions). Of course for 'OECD Europe' there is a list of countries (and corresponding ISO codes), that could be provided, but no data points on a country level.
I could envision coming up with a 'regional code' for all the regions we use and is then interpreted by Tableau the same way the countrycodes are used!?
1 of 1 people found this helpful
I've attached a two files, the Region Map and the Excel spread sheet used to produce it.
Here are the steps I went through to produce the workbook:
- Got a list of countries in each region (Wikipedia)
- Dumped into Excel. Added a 'Region' column.
- Put country on level of detail shelf and Region on the color shelf
- Right-click the map, click 'View Data', highlight all columns and then click 'Copy'
- Paste this into a new Excel spread sheet
- Connect to this new sheet, now you'll have two sets of lat/longs.
- Using the non-generated ones build a dual axis map like the one attached.
- You'll need to adjust the labels (North America will be down in the Caribbean, for instance.)
You can now color your map with any measures you have. Note that on one axis the color is set to 0 (off) so use the other axis. Let me know if you have any other questions.
Shawn, thanks so much!! I did not have time to look at it over the last day, will do so over the weekend.
your solution works well, thanks! The only tweak I am looking for is that values I calculated for a region are only shown once (i.e., displaying the value for South America one time and not each time for every country). It would also be cool if possible selections are actually limited to regions. Is there a way to do that?
Christain, it sounds like you are putting your values on the wrong shelf of the dual axis.
Put your value field on the label shelf in the AVG(Latitude) (2) mark card (not the other one). If you want to show both the region and the value you'll need to create a calc like something like this:
[Region] + "
" + [My Value]
Then put this on the label shelf. This should give you this:
You can limit to a particular region using Actions, Filters or Parameter/Filters. Just depends on how you want things to work.
i have another file with values corresponds to different regions by years, not sure how to just display the regional data using the formula, because system prompted me that can't add string and numerical values together.....sigh