conditional formatting color based upon another field value

VRIndy

I have a Symbol + Grouped Bar chart that I would like to use conditional colors.

 

X Axis is Customer

Y Axis is (Max)Goal

Series is (Avg) PercentOnTime

 

I would like to do the following:

 

If (Series) PercentOnTime >= (Y Axis) Goal = (Series) Green

If (Series) PercentOnTime < (Y Axis) Goal = (Series) Red

 

Any help would be greatly appreciated.

jhl

I do not think this is possible using the existing color rules in analyzer.

 

However, you might want to take a look at Adding Graphics, Links, and Images to Table Cards Using Beast Mode from the knowledge base. The same logic (using CONCAT in beast mode to insert html code) may apply and help you achieve what you want.

 

HTH

VRIndy

Thank you.  I will take a look at that.  

user00820

did you figure this out?