Bubble Chart Bubble Size - need to make constant, or at least smaller
Hello,
we are trying to create a Matrix graph using Bubble chart in Report definition. Our desired look would have very small bubbles, almost just a point. We have tried to achieve this using constant values retrieved from sub-report
We have tried using and aggregating these values in all possible ways, but did not achieve the desired result. The smallest bubbles, using value '0.01' we could achieve look like this. Smaller values returned 0 and in the end show the same bubble size. As we can see, the size is much, much larger than 0.01 and for some reason looks like ~0.7 This is unfortunately not sufficient, as the users would like to be able to see the bubbles' centers with at least 0.1 precision, which is possible, but definitely not user friendly with such large bubbles.
I will welcome any suggestions or tips how to achieve better manipulation with these bubble sizes.
Hello,
we are trying to create a Matrix graph using Bubble chart in Report definition. Our desired look would have very small bubbles, almost just a point. We have tried to achieve this using constant values retrieved from sub-report
We have tried using and aggregating these values in all possible ways, but did not achieve the desired result. The smallest bubbles, using value '0.01' we could achieve look like this. Smaller values returned 0 and in the end show the same bubble size. As we can see, the size is much, much larger than 0.01 and for some reason looks like ~0.7 This is unfortunately not sufficient, as the users would like to be able to see the bubbles' centers with at least 0.1 precision, which is possible, but definitely not user friendly with such large bubbles.
I will welcome any suggestions or tips how to achieve better manipulation with these bubble sizes.
I will also mentioned that we have of course tried linking the BubbleSize to properties, some size relativity wouldn't be an issue - however, all rows and all columns have 'null' values in some places. This is absolutely necessary due to different aggregations for different reports. The issue is, if I do any calculation [even adding] where we interact with a 'null' value, the result always comes to 0. Is there a way to add/combine two values within report column, so we get a 'decimal number' result?