0 Replies Latest reply on Nov 28, 2018 12:03 PM by Majed M

    conditional format multiple aggregate values

    Majed M

      Hi,

       

      I am building a KPI based on turnaround time (average, median and 75 percentile) for 5 cases categories. Each "Case Category" has its own benchmark. (b1=10, b2=7 etc..)

      Is there a way to color code the values based on both dimensions and aggregate measures. For example, IF [case category] = "xx" and median, median and percentile  [TAT] <= "##" then ###.

       

      Thank you

      M

       

      Message was edited by: Majed M