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.
Yeah, that's kind of how that visualization works. You might want to try the ESRI visual or a custom visual.
Thanks Greg_Deckler
I tries the ESRI visual all I could get is within the same bubble
I guess the question I have is what are you expecting? It seems like you have multiple things sold in the same city for different "Bill to Party"'s. If you only had a single "Bill to Party" per city, then the bubbles would be different colors but since you have multiple then the visualization has to figure out a way to display that fact. How would you prefer that it display the information?
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.