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.
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.