Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working with incident data in the following format where each row details one registered incident:
ID | Priority | Component |
---|---|---|
1 | Severe | Till |
2 | Moderate | Software |
... | Critical | Hardware |
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,
How about this
=Count({1<Ccomponent = {"=Num(Rank(Count({1<Priority = $::Priority>}ID), 3, 1)) <= 5"}, Priority = $::Priority>} ID)
May be this:
Count({1<Ccomponent = {"=Num(Rank(Count(ID), 4, 1)) <= 5"}>} ID)
This doesn't seem to be what I'm looking for. I'm also not sure what Num does in this context.
To be clear what I want is a count of the ID's for the top 5 components that will only vary if a selection is made on the Priority level. If any other selection is made I want nothing to change.
Would you be able to elaborate as to what you are trying to get
"what I want is a count of the ID's for the top 5 components that will only vary if a selection is made on the Priority level. If any other selection is made I want nothing to change." This what I am trying to get.
I would like the result to filter down if a selection is made in the Priority field but not if a selection is made in the component field. And I would like the result to always show the count from the top 5 components within the selected Priority level.
I think it would be better if you can point out the expected number based on selection in different Priority level selection. If I have the numbers you are trying to get, I might be able to help you better
No Priority selection: 280
Priority 1: 42
Priority 3: 190
Priority 2 + Priority 3: 236
And if any component or set of components is selected these numbers should not change
Check out this expression:
=Count({1<Ccomponent = {"=Num(Rank(Count(ID), 3, 1)) <= 5"}, Priority = p(Priority)>} ID)
Hi Sunny,
Unfortunately this doesn't seem to work for me.
If I make a selection on one of the components it updates the total. I do not want this to happen. I just want the total to update if Priority is changed. See below. The total should not change for the bottom KPI.
How about this?
=Count({1<Ccomponent = {"=Num(Rank(Count({1<Priority = p(Priority)>}ID), 3, 1)) <= 5"}, Priority = p(Priority)>} ID)