12 Replies Latest reply: Jul 28, 2016 11:11 AM by Conor O'Kane RSS

    Rank Filter and Selection Filter in Set Expression

    Conor O'Kane

      I am working with incident data in the following format where each row details one registered incident:

       

      IDPriorityComponent
      1SevereTill
      2ModerateSoftware
      ...CriticalHardware

       

      I attach some sample data.

       

      I have a list box/field that allows for the user to select the 'Priority' level. I am trying to create a KPI that does the following: Counts the number of incidences - i.e. Count(ID) - only for the priority level selected (or all if none selected) and only for the top 5 components by Count(ID).

       

      I have attempted the following with no joy:

       

      Count({1<[Priority] = P([Priority])>*1<[Component] = {"=Rank(Count([ID]))<=5"}>} [ID])

       

      Any help would be greatly appreciated.

       

      Kind regards,