Is there a way to calculate percentiles in Omniscope 2.7? If not, is it possible to add this functionality in by generalising the Subset_Median function? This would be very helpful in terms of keeping some of our reports in an Omniscope format. Thank you, Ariel
Ariel - Version 2.7 is now stable release and nothing is being added to this version. I have re-classified this as an Idea because there is currently work going on in version 2.8 to augment the number of ways Omniscope can segment sets of values into 'tiers' i.e. quartiles, top/bottom 10%, cumulative 80-20% 'Pareto' type charts/analysis etc. Please outline your exact requirement and you may be able to use it in an early version of 2.8 Alpha when it becomes available.
I was aiming to reference the "95th Percentile" across a range of figures in a contents view. I'll try using rank and interpolating to calculate this as a workabout for the moment.