4 Replies Latest reply on Jan 16, 2020 4:57 PM by Paul Wachtler

    Map Not Accounting for State Name Variations

    Katerin Rodriguez

      Happy Monday!

       

      I am trying to create a map viz that gives a count of ids by state. My data has some variations for state names (AZ,Az,Arizona,az) and I am noticing that the viz only seems to be counting entries that have one variation rather than aggregating all of them. I have gone to the edit location option and matched all the field entries to the corresponding state, but it still will not update to show the overall number by state. I tried to group the dimension, but then I cannot get a count by ID for the color mark.

       

      Has anyone run into this before? How can I ensure that all variations of a state name are matched to the correct location?

       

      Thanks!

       

      -Katy