3 Replies Latest reply on Apr 24, 2018 5:06 AM by Jim Dehner

    How to set up an aggregate value to change colors based on set target values

    Henry Lau

      In the below picture, i would like to set the values (it is an aggregate value) to a certain colors based on the below criteria

       

      Greater than 99.4% is Green

      Greater than 98.9% but less than 99.4% is Yellow

      Less than 98.9% is Red

       

      I tried using calculated field but however it gives an error that an aggregate value cannot be further aggregate.

       

      Appreciate some help here...

       

      Thanks!