7 Replies Latest reply: Apr 28, 2016 5:18 AM by Manish Kachhia RSS

    KPI Expression checking

    Subba Reddy

      Hi Folks,

       

      Please find the below snippets.

       

      when user selects Temp Filter as "Critical" or "Hot", the first KPI (Type1 Critical/Hot) no need to vary. It will be fixed.

       

      In the below pics it was varying the values.

      Pic1.PNGPic2.PNG

      Please find the below expression, i am using for this KPI.(Type1 Critical/Hot)

       

      =If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

      Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

       

      How to static it?