Bubble Chart

[Anil_Babu_Samineni]

Hi,

I am stuck at Bubble chart.

Please find attachment and see the Sheet1, I have dimension is Name and i want to create one bubble chart with Y-Axis is score of avg with two exclude names like Key Message Delivery, Sales Objective Category.

And I want to show bubble is Count(groupObservation).

I want to see very clear with bubble size accuracy Good.

- Anil

[susovan]

Hi Anil,

Is it your requirement?

[Anil_Babu_Samineni]

Can you please send the qvw

[susovan]

PFA

[Anil_Babu_Samineni]

As per client requirement,

Dimension is Name(X-Axis)

Expressions:

1)  Y Axis - Average of Score ( so, here i want exclude those two names)

2)  Z Axis - Count of groupObservation

- Anil

[avinashelite]

To exclude try like this

Avg({<Name={'*'}-{'Key Message Delivery', 'Sales Objective Category'}>}Score)

or

Avg({<Name - ={'Key Message Delivery', 'Sales Objective Category'}>}Score)

[Anil_Babu_Samineni]

I tried this, But still chart showing the values.

PFA.

- Anil

[avinashelite]

Could you share the screen shots which demonstrates the issue with dimension and expression because i don't have the QV license

[jonathandienst]

You need to exclude from the second expression as well:

     Avg({<name -={'Key Message Delivery', 'Sales Objective Category'}>} Score)

     Count({<name -= {'Key Message Delivery','Sales Objective Category'}>} groupObservation)

[Anil_Babu_Samineni]

How to increase the Bubble size?