conditional formatting color based upon another field value

VRIndy · November 2017

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 · November 2017

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 · November 2017

Thank you. I will take a look at that.

user00820 · January 2018

did you figure this out?

Best Answer