Forum Discussion
90th Percentile Issues (Not displaying correctly)
Yes. If you do not already have an Index, you can create a Calculated Column as follows.
NOTE: I am assuming you have an ID in your table. Since you have duplicate values in the Unit Turnout Time, you need a way to differentiate between duplicates to assign different ranks for the same Unit Turnout Time. In this example, I'm simply adding the ID to the Unit Turnout Time to get a unique value on which to properly rank all values.
Once your Index column exists, just update the measure to refer to it inside the CALCULATE.
Hope this makes sense.
Nathan
WinterMist - I attempted to use the formula you added above, it returned no value under 90th Percentile.
- WinterMist
Impactful Individual
That is because of the highlighted line in your measure below.
The CALCULATE is asking for the Unit Turnout Time where Unit Turnout Time = 21.
But there is no value in Unit Turnout Time of 21. So it returns nothing.
Instead, you want to get the Unit Turnout Time for the 21st record in the list.
This is why I used an Index / Linenumber column, that simply tells you what the linenumber is.
The highlighted line in the measure below is asking for the Unit Turnout Time WHERE Index (i.e. Linenumber) = 21. In this case, Index 21 exists, and is able to find the result.
Does this make sense?
WinterMist - Yes it makes perfect sense so my question is how can I take the following data and 'select' the right number? Do I need to add an index colum so each turnout time has a specific index number to go with? Ultimately I would like like for it to display the number selected vs showing the entire list of turnout times.
I am open to communicate elsewhere if we need to.