I'm sure it's me, but I'm a little confused by the question being asked!
The level 1 you show in the Table [France, Italy, FL_GA_AL, FL_GA_AL...]...is that a field in your data? if so can you not just add that to the colour shelf?...or are you asking how to create that field (in a calculated field)...or something completely different!!
Thank you for replying. I'm sorry it might not have been clear enough.
Yes that is a field in the data and I can add it to the color shelf. The problem is Tableau only looks at the country code for the US and gives it one color.
ah so the problem is drawing a map from different levels...once we have that we can use the Level 1 pill on colour!
So i created a field that would only return a country code if the state was NULL (you state field already does this, as both FR and IT are NULL for state)
[Country Code (if no state)]
IF ISNULL([State]) THEN [Country Code] END
so this does this
now tableau doesn't (well can't!) plot nulls, so we can now make a dual axis map. Where one axis is at the State Detail (so IT,FR can't get drawn), and the other Axis at the level of our new field (where it is unable to draw countries which have states)...and then we can apply the Level_1 to the colour tile for both Axis
Going forward you may want to look into Tableau 10s new custom territories feature...could be just the thing you need here. This video covers some other T10 features, but has a great section on custom territories Tableau 10 Preview with Zen Master Joshua Milligan - YouTube
Thank you! I was watching the video on custom territories and that feature seems great!
Using the data set above, and knowing it is several hundred rows, with 3 levels of geo 'groups'...is it possible to have Tableau create groups based on the data above so I can then create custom territories?
Excellent stuff...and thanks for posting back those links
I've not played withe custom territories yet, so didn't realise you could create the custom territories of different levels of geography (ie. some are built from country level and some from states). Is that what you were able to do?...or did you have to have everything at 'state' level and then build Italy, say, from all the states in Italy?