3 Replies Latest reply on Dec 29, 2016 1:59 PM by Norbert Maijoor

    Conditional Formatting on Cells with Measure Values

    Kyle Boyce

      I'm trying to create a Pace Chart (seen below). I would like to color each cell according to the % to Pace or % to Goal, but when I tried the coloring calculated field it was looking at each measure in each office and if just one of the measure values was above target, then it would color the whole row that status color. For example if Metric 1 was 110% and Metrics 2 and 3 were 50% it would color all the metrics for that office Green.

       

      I think it's just an issue with my logic in the calculated field it was just a lot of ELSEIF'S, Any help would be appreciated.