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's in different colour. When I tried to add bill to party in the legend field it created with different colours but in the same bubble as shown in the picture. All I wanted is to show them as different coloured 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.
8 Replies
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?