I have created a calculated field to visualize sales territories in North America in the following manner:
CASE[STATE/PROVINCE]
WHEN "YUKON" THEN "REGION 1"
WHEN "NORTHWEST TERRITORIES" THEN "REGION 1"
WHEN "BRITISH COLUMBIA" THEN "REGION 1"
... etc
This works just fine and I am able to display the different regions as different colours. However, some of the mark labels for the sales for State/Province data does not display when labels are turned on. Only four of them do not work (Montana, Florida, Indiana, and Maryland.) Two of these (Florida and Montana) were 'unknown' and I had to put the latitude and longitude in for them to be recognized. Also, just to be clear if I hover over the State with my cursor the data is displayed. It is just the label that does not show up for these four States.
I'm also wondering if anyone know's a quick way for me to fill in the State/Provinces that have no data to be included in the Regions I have created.
Thanks!
Hi Ian,
The geocoding isn't matching because it can't figure out which country the states are in. It either assumes they're all in the US or in Canada, and uses that country name as a constant.
The simplest way to fix this in a small data set is just to add an extra field called "Country" (or similar) and populate it with the appropriate values. Like so:
Then set the Country value to this field and it should work the way you want.
Does this work for you?
Thanks,
Steph
