Displaying a color expression value on scatter chart

[#1]

Hi. I have a scatter chart that uses the required expressions for the x and y axes, I also use a third expression to determine the size of the bubbles. When I hover over a bubble all three of these values display just fine.

But I have a fourth expression that I used to determine the color of each bubble. I can't seem to find a way to get the value of this expression to display when I hover over a bubble.

The expression for the horizontal axis gives me the average list price of an item.

The expression for the vertical axis gives me the average revenue received from a sale of an item.

The expression for the size of the bubble tells me how many items we sold.

The expression that determines the color of the bubble (the value I can't seem to see) tells me the average discount applied to a sale of this item.

The background color expression is applied to the Average List price formula.

Is there anyway for me to see the value for this fourth expression?

Any help would be much appreciated.

(simplified document is attached)

[rbecher]

Hi Nathan,

please find attached. You can just add another expression and check "Text as Popup".

- Ralf

[Roop]

I would suggest adding the expression for Discount as:

'Discount = ' & avg([% Discount] * [Avg Achieved])

and then checking the button that says "Text as Pop-up".

This will give the discounted value in a pop-up when you hover over the relevant bubble.