Bubble size

[ravindraa]

Hi all,

   I have struck in place please give me suggestion to come out on this.

   I have crated scotter chart my expression sum(Polarity), and count (CustID) i want to display bubble's size  based on the sum(Polarity)wise.  In Expression tab i have given two expresion and bubble size expression also. Here the problem is my bubble are changing for positive values but bubble are not showing for negitive values.

  What i have to do to change for negative values.

Thanks in advance.

thanks & Regards

Ravindra

[nagarjuna_kotha]

Hi Ravi,

Can you attach sample file ?

-Nagarjuna

[tresesco · Accepted solution]

Negative size - is not feasible. Hence, you don't see any bubble for them. Alternatively you can take absolute values of the negatives using fabs(), and possibly use a some fixed disdinct color (background of the bubbles) for negative values to distinguish from others.

[jonathandienst]

You may need to clip the negative values to some low positive value (RangeMax(expr, n)), or display the absolute value (Fabs(expr)) using colour to show positive or negative values (although you would lose the legend value of the colours).

Is this the best possible visualisation pf the data?  What are you trying to display? Is suggest that you post a sample qvw file, and details showing what you are trying to achieve.

[ravindraa]

Hi ,

Please find the attached sample application and data file.

[ravindraa]

Hi Tresesco/Jonathan,

Thanks for replaying i want to show the region wise scotter chart , in that chart i have to show negitive values also but the size should be change based on the Polarity wise .

Thanks& Regards

Ravi

[tresesco]

Something like attached sample?

[nagarjuna_kotha]

Hi,

PFA...

[jonathandienst]

Normally, the axes in a scatter chart are ordinal numerical values - in your example, your x-axis is a customer ID, which is not ordinal. So a scatter chart is almost certainly not the best visualisation for your data. I suggest that you think about what sort of question this chart should answer and come up with a better visualisation.

[tresesco]

Or, alternatively you can take the min value to to set - 10 (or a minimum value you need) and add up the value difference to the expression to maintain the relativity of the values (bubble sizes).

=Sum(Polarity)-$(=Min(Aggr(Sum(Polarity),Region)))+10