1 of 1 people found this helpful
use a T/F type measure and add it to color shelf.
Thanks Brian...I assume if I have three stages of the metric, I can just use an if/else statement to accomodate three colors?
t/f wouldnt work for 3. i was wondering that and are the pre determined goals % prob different for each company?
Try like this as example:
if [Value]> 430.00 then "Alert"
elseif [Value]< 430.00 and [Value]> 420.00 then "Border"
elseif [Value] < 420.00 then "OK" end
I was doing this on a line but if your doing it on bar and have the goal next to the actual % of goal i would just save a few steps and select multiple mark types, then check on the % of goal bar specifically, then put that measure value pill into the color box for it and use the temperature diverging color or custom etc. then you can set up the scale to be pretty accurate as to the color for how much % of goal they are....