Retrieving a specific percentile value from result-set
All,
I am trying to determine if there is a way to dynamically retrieve the 85th, 75th, 65th, or some percentile value from a set of records using one or more of the built-in BI functions?
I have different input values and therefore this (percentile value) needs to be dynamic based on the result-set. The current PERCENTILE function gives a result of 0 to 1 (using default setting), unless I over-ride the field setting. I can not use the percentile function telling it I only want the 85th, 75th or some percentile value (like Oracle) and get the resultant day value. I am trying to find a single value in days from the result set of data using NTILE, or PERCENTILE or something.
I can mathematically find the Ranking for my specific percentile value, but I can't pull THAT specific day value out of the result-set and use it in a calculation to get my final day value.
Any thoughts??