Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieving a specific percentile value from result-set

user10860434Jan 28 2009 — edited Jan 29 2009
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??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2009
Added on Jan 28 2009
3 comments
677 views