I have some survey data that I'd like to show on a filled map. Its original form is as follow:
But I'm not sure how to get a visualization where I can group multiple states/provinces to show a single data point. My current workaround is to simply list each province separately, which yields a misleading visualization (as in, 23% in Saskatchewan + Manitoba combined is not the same as 23% in Saskatchewan, then 23% in Manitoba).
|Prince Edward Island||31%|
|Newfoundland & Labrador||31%|
So yeah, all I want to do is show the original data set correctly on the map by aggregating some of the provinces into regions to reflect the way the survey handled the data. Thanks in advance!
There is a feature in Tableau 10.0 called Custom Territories:
There is no similar option in version 9.x sorry.