One of my users needs to report on the middle 80% of test scores. What this means is that she needs find the range that is left when dropping off the low 10% and top 10%. Is this possible within Salesforce?

Example:

Say we have test scores of 1,2,3,4,5,6,7,8,9,10. The middle 80% would be 2-8.

Alternatively, if I can just identify what scores fall in the bottom 10% and upper 10% I can probably make that work.

Attribution to: Mike Chale

Possible Suggestion/Solution #1

• Create a batch class that analyzes all of the test records, calculates the top and bottom cutoff values, then stores these two values in a Custom Setting.
• Then create a formula field on your test object that compares its own score with the Custom Setting values, and use that field to filter your report.

This batch would have to run after any inserts, updates or deletes in order to be current; it could be scheduled for a nightly run if necessary. Also, this is only practical if you are always analyzing the same data set by the same dimension. If you need to be able to do this by month, by year, by geography, etc, it becomes increasingly complicated.

Attribution to: Jeremy Nottingham
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/1760