List Box to determine the bubble size from a scatter chart

[danialier]

Hello,

Does anyone know how to create a list Box to determine the bubble size from a scatter chart ?

thks,dani

[swuehl]

Could you detail your requirements a bit closer?

Do you just want to show the third expression value per dimension?

Use a field expression in your list box:

=Aggr( YourBubbleSizeExpressionFromScatterChart, YourDimensionFromScatterChart)

[danialier]

Hi Swuehl,

I'd like to have a list box (or another object) where to be able to select a bubble size from a list of different types of bubble sizes.

Doing this way when looking a WW map I can select a bubble size and then when zooming-in at country level I can select another bubble size.

Do you know if that is possible?

Thks,dani

[swuehl]

Yes, might be possible using a field expression (select <expression> from field drop down on general tab of the list box properties), like

=Aggr( Sum(Sales), CustomerID)

Replace the expression and dimension according to your setting.

You can't really get the bubble size, but you can create kind of buckets for the bubble expression in the scatter chart as well as the list box:

Round((Sum(Sales)-Min(Total Sales)) / (Max(Total Sales) - Min(Total Sales))*10)

[Anonymous]

Hi Dani,

Why do you want to use a list box?

I think that is better to use a Slider with a variable, and use this variable to get bubble size.

Kind regards!