Dimension Limit issue in Scatter Chart

[udaya_kumar]

Hi,

I have a created a scatter chart with 1 dimension and 3 expressions.

I have given Largest 10 values from the Dimension Limit of the chart and also i have checked "Show Others" option.

I am not able to see a bubble in the chart for Others, but Others is present in the legend.

But i want even the Others as a bubble in the chart.

If i click the others from the legend, then it drill downs to the values of the dimension other than largest 10.

But i want a bubble to be shown even for Others in the chart.

How can i achieve this?

[#2]

i would suggest you add a calculated dimension in this case rather than using Dimension limit.

aggr(if(rank(measure, <dimension>) <=10, dimension), "others')

[udaya_kumar]

Hi Ram,

This is the expression which i used

=aggr(if(rank(Volume, Name) <=10, Name), 'others')

It did not work.

[tresesco]

Try like:

=aggr(if(rank(Sum(Volume)) <=10, Name), 'others')

[udaya_kumar]

Hi,

I tried that expression, but it is not working.

It is not showing anything.

Please find my file attached.

[tresesco · Accepted solution]

Corrected!

=aggr(if(rank(Sum(Volume)) <=10, Name, 'others'), Name)              //working

[muniyandi]

Hi Uday,

use this expression in calculated dimension. if(Aggr(rank(Sum(Volume)),Name)<=10,Name,'Others')

Kindly refer my attachment file.