I am trying to map Sales Dollars by state/province, but some of my locations are being mapped incorrectly. For example, I have the province Nova Scotia in Canada being mapped to New South Wales in Australia. In my data, the province is listed as NS. I have tried making a new column that lists it as NS, Canada but it still maps to Australia. I have also tried listing it as NS, "zip code", Canada but it still maps to Australia. I have kept the data category to state/province in all these scenarios.
It also seems strange to me that if I map the column with just state/province abbreviations, it maps some states differently than if I map the column with "state abbreviation, country" (keeping both data categories as state/province). For example, if I map my locations using only the states, Texas is filled and British Columbia is not filled, but if I map "state abbreviation, country" then BC is filled and Texas is not filled. Any ideas why it is doing this? Thanks!
