Forum Discussion
Bubble size for negative values in map visualisation
Hey Anonymous , hey parry2k
please excues i hit the "mark as answer" button by accident, please uncheck the post as answer.
I just wanted to say: just multply the [cost] measure with -1, this will "convert" the largest negativ numbers into the largest positive numbers and vice versa. Then you will also have the proper bubble size.
I assume you have to be aware of the "tooltip".
Regards,
Tom
Anonymous solution is attached, I believe this will do it. Take a look. There are 3 measures and also have to use tooltip page to show the tooltip on the map, and "Cost Bubble" measure will give the size.
Super UserTomMartens unfortunately that approach will not work, think if all numbers are positive, in that case multiplying by -1 will take largest +ve number to largest -ve number and that is not Anonymous wants.
Super UserAnonymous solution is attached, I believe this will do it. Take a look. There are 3 measures and also have to use tooltip page to show the tooltip on the map, and "Cost Bubble" measure will give the size.
- parry2k
TomMartens Sorry I think what you suggested would work, you are right as always :) Only thing he has to do is to create a tooltip to show correct number which you already suggested.
Anonymous please use TomMartens approach and create a tooltip page to show correct value.
parry2k TomMartens both ways work, toms way is probably the least complicated.
Just a query though, when i do it by multipling by -1 and using this as the bubble size is there a way of removing that number from appearing in the tooltips. Even though it helps for achieving the size of the bubble, when i hover over the value it is telling me for instance the cost is $500, whereas i want it to only say $-500. I can put the original column in as a tooltip to get that -500, but can i remove the $500 value (which is determining the bubble size) from appearing when i hover over a bubble, aswell as removing the longitude/latitude values.