Forum Discussion

markjohnson952's avatar
markjohnson952
Icon for Helper I rankHelper I
5 years ago
Solved

Shape map duplicate counties

I am using the Shape Map with a TOPOJSON to identify sales by county.  In the cases where you have the same county name in multiple states (Jefferson, Orange, Washington) my sales numbers are all the...
Need Help
markjohnson952's avatar
markjohnson952
Icon for Helper I rankHelper I
5 years ago

Hello,

 

In my data, my counties are just listed as a text string.  Hennepin is just listed as Hennpin for the county.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi markjohnson952 - this could be the issue for the conflict as the visual would not be able to differentiate between counties with the same name in different states. You would need to setup a county key which is unique for State + County combination - in my opinion this should help resolve the issue. 

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

    • negi007's avatar
      negi007
      Icon for Community Champion rankCommunity Champion
      5 years ago

      markjohnson952 I had faced similiar issues when i was working on one of my dashboard. I had same district name in multiple states of India. To tackle this problem, I renamed the district name for having same name in the JSON file like District_1, District_2. This wasy I was able to resolve this issue. In your case also try if changing the name of Jefferson, Colorado to "Jefferson, Colorado" and same way change the name for other county. Give it a try for few counties. If it works. you may do it for all counties. Let me know if it helps you.