Dear Tableau Community
I have state/province level data in different countries (Japan, US, Indonesia, Mexico, England). I wish to draw maps of each in one tableau workbook. However when I select state / province as the geographic role for my variable "location name" tableau does not recognise my state level locations. Tableau requires me to also select country / region within "edit locations".
This works for one visualisation (eg Mexico in the attached workbook). But then if I try to draw a map of the US, tableau still thinks the country/region is Mexico. If I change this to the US within "edit locations" in the second visualisation, the Mexico map disappears. I tried to get round this with having a separate variable for each collection of subnational locations (Japan, Mexico, US, Indonesia, England), but this also didn't work. I know I could have separate workbooks for each map, but this seems cumbersome. Any suggestions of how to get round this?
Also - a separate issue - most of the Indonesia state level locations don't seem to be recognised by Tableau - any suggestions for fixing this?
Best Wishes
Joe
Good morning
there is a field in the data Parent id - convert it to a geo field
click on the Icon on make it geo as shown
then drag location name under parent id to make a hierarchy
you can create a single viz with the hierarchy parent-id/location game on detail add parent id to filter to select the "country" you want
and you can then drill to the level you want to see
JIm
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
