3 Replies Latest reply: Feb 17, 2016 4:18 AM by Sangram Reddy RSS

    Issue in KPI coloring

    Prasanta Kumar

      Hi,

       

      I am trying to use expression to color the results, but it seems like its not working.

      please advise if i am doing something wrong here (please refer the screen shotCapture.JPG

       

      I have an expression as below for one of my KPI

       

      round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

      /

      (sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

      {$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01)

       

      and for coloring i am using the below

       

      if((round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

      /

      (sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

      {$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01))<.90,red(),green())