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

    Rank Filter and Selection Filter in Set Expression

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




      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,