Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Got It..
Hi Anil,
Is it your requirement?
Can you please send the qvw
PFA
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
To exclude try like this
Avg({<Name={'*'}-{'Key Message Delivery', 'Sales Objective Category'}>}Score)
or
Avg({<Name - ={'Key Message Delivery', 'Sales Objective Category'}>}Score)
I tried this, But still chart showing the values.
PFA.
- Anil
Could you share the screen shots which demonstrates the issue with dimension and expression because i don't have the QV license
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)
How to increase the Bubble size?