Forum Discussion
Create a map showing data on different bubbles
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.
Yes Greg_Deckler there are multiple Bill to Party's with in the same city . I need a way to show the different bill to party's over the country in different coloured bubbles. For Example, Lets take Texas which has 3 different bill to party's A, B and C. I want to show the Net $ amount of A in blue bubble, B in grenn bubble and C in red bubble. Not all within the same bubble like in the ESRI map.
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?
Greg_Deckler to be honest i still don't know how to show two separate bubbles in the same location instead of piechart. I've prepared sample dataset. Could you help?
