Setting different color via Expression

[brunolelli87]

Hello guys,

I'm using the following expression to color my bars depending on its value...
If it's above the TTOAL average (red), otherwise (green)

IF(AVG(TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))

But, in this case, if the user selects some bars, the system will recalculate the colors again based on the available remaining bars.

How can do not change the colors in this case?
I mean, once it's calculated the colors should not change anymore upon users' selection.

Would that be as simple as replacing the TOTAL by ALL?

IF(AVG(ALL FSPLU) > AVG(FSPLU), color(3), color(2))

Thanks

[Saravanan_Desingh]

So, do you want to compare the overall AVG with currently selected AVG?

IF(AVG({1}FSPLU) > AVG(FSPLU), color(3), color(2))

[brunolelli87]

What's the difference between 1 and ALL?

Thanks

[rwunderlich · Accepted solution]

You will still need TOTAL

IF(AVG({1} TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))

{1} and ALL are the same. ALL was deprecated when replaced by {1} and ALL was meant to be removed from the product. However, the removal never happened.

-Rob