One solution could be to create an additional column with country names in Asia and then create a map on the country level. Once that is done you can group the countries in Regions.
You are right, I thought of this, but as soon as I switch to symbol maps the data would be by country and I do not have the data at that level but only for Asia US and Canada. But thank you for responding, I might try this too.
Thanks Swaroop! I saw this. The custom territory does not support Asia Longitude, Latitude, if otherwise would be very helpful!
I went through the spread aggregated regions link: but I have a question, my data does not have records by country, they look like below:
I want the map chart to show US, Canada and Asia region which could act as a filter for other sheets on dashboards
Client details Client satisfaction index Region Business Units Age Q1 Q2 Q3 US US1 65+ 4 5 5 Canada CA1 50 to 64 1 5 5 Asia AS1 50 to 64 5 4 4 US US2 50 to 64 2 3 1 Canada CA1 50 to 64 4 5 DK Asia AS2 65+ 3 2 4 Asia AS3 50 to 64 DK 5 5 Canada CA2 35 to 49 5 4 4 Asia AS2 35 to 49 2 DK 3 Asia AS3 50 to 64 5 5 5 US US3 50 to 64 5 5 5 US US1 65+ 1 5 4 Canada CA3 50 to 64 DK 3 5
This likely isn't sufficient, but I made a quick pass at grouping countries using
the methods described in these links:
As discussed here:
Got the list of countries and continents from here:
Then grouped the countries like this:
(I yet didn't code all the Asian countries, more work to be done)
Please see workbook v10.3 and datasource attached in the Forum Thread
Thanks a lot for this work around! I will be trying this today.
Could you please let me know where I could get the data source and workbook you spoke about, so that I can refer to exact - Please see workbook v10.3 and datasource attached in the Forum Thread (I cannot find any attached)
when you grouped the countries, did you blend the data as another data source with the original data?
Something like this-
Excel 1: my data source: region(Asia, US,Canada) and other columns(age, Q1,Q2,Q3)
Excel 2: region and countries list (from the Group countries in to continents?)
and then mapped by region in tableau?
Because I am not able to blend it correctly too.
This is the exact countries I need to be shaded (not all of Asia), but I cannot join as data is not by country.
Business group Country(only for map chart, data does not exist at country level) Asia HongKong Asia Phillipines Asia Malaysia Asia Indonesia Asia Vietnam USA USA Canada Canada
I think you may have found that attachments can only be seen
in the Forum Thread in your browser; cannot be seen in email.
Narrowing down the countries makes it easier.
Attached in the Forum thread is the revised datasource and workbook.
I am joining the two sheets, rather than blend. Please see diagram below.
Thanks! I found the workbook and excel too.
I tried blend as well as joining the countries table to the data. Unfortunately, on join the rows increase as (1 row for asia now becomes 5 rows with same data + that unique country) and hence when I do the validations, count/sum of any measure it increases due to additional rows.
and blending is not letting me create correct filters as the data source changes.
For duplications, you can try
Thanks for this suggestion, unfortunately I am working on weighted survey data - that means the calculations of NPS from scale to score (-1,1,0) plus applying weights to them is also complex, I am not sure how the LOD function would work on those complex calculations.
I am sure the blending does not duplicate. However, since I want to use the map chart as regional filter on the dashboard, blending does not allow me to filter other sheets as country-group is another data source and rest of data is another
Here is an update and help needed:
I tried 2 ways:
1. Join the countries sheet to the data sheet (gives me duplicate rows, and the complex calculations don't validate, I doubt if I can use the LOD for all levels of calculations, I have about 16 calculated fields using this)
2. Blend the countries sheet to the data sheet (not able to use the map chart as filter for other sheets since the map chart is from "countries" source and other charts are "data" source.
I need help to understand how to use a chart as filter (from data source 1 blended) to control other sheets on dashboard (from data source 2)
I think there are general solutions to what you seek,
but it will be difficult to give specific suggestions without seeing
how your data is arranged.
If it would be possible, please post some spreadsheets of
a small amount of fake data in a form that approximates
your true data sources.
Better still would be a workbook connected to that fake data
showing the blends you are describing.