Forum Discussion
Create a map showing data on different bubbles
I have a data set which looks like as in the picture. I want to show the Net $(order) by different Bill to Party on the same map like the Net $ of 1611685 should be in yellow and other bill to party'...
OK, what you could do is to pick a specific city for each bill to party in each state. So, let's take Ohio for example. You could essentially "assign" Bill to Party 1 to Columbus, 2 to Cleveland and 3 to Cincinnati let's say. You could create a custom column that essentially adds the correct city to your Region field based upon the state. Then you could geo-code that column and you would end up with 3 different bubbles, 1 for each Bill to Party and they would be different colors, etc.
Thanks Greg_Deckler
This would be the solution if I view it on state level right. Because there is drill down option in my graph where the state level gets drilled down to city level.
Use zip code?