Forum Discussion
Map Bubble Size by Duplicate City Names
The title really says what i am trying to do. I am trying to create one bubble for a city(ie Atlanta, GA) that has say 20 different addresses.
Is there a way to count all the duplicates and then make the value the bubble size and then just have a another table for city state with the duplicates removed and have those indexed(id) to the main table?
1 Reply
- HotChilli
Community Champion
You don't need another table, just add a column which is city, state. (you might have this column already)
Drag that column to Location, then drag the same column to Size and make it a Count
