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

    KPI Expression checking

      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.


      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?