Need to compute percentiles. How to do this in Board?
Hello,
For a given set of values we need to know the percentile which corresponds to each value. Cumulated Vertical % does not seem to help but I could be missing something. Say I want to know whether a given cube value is in 75th percentile or better?
Thank you
Answers

Hi Peter,
I think you can do this with the 8095 Ranking function or on a sorted DV (according to your figure) or using Cumulated Vertial (also on a sorted DV) together with an Algortihm to specify your percentile
regards
Björn
3 
Hello Björn,
Thank you for your reply. In the DV example you give the top two entries are 75 percentile or greater. The middle entry "fixed blade" is at 50th percentile (the median). The trouble I'm having with CV and 80/95 is they are concerned with value and percentile is concerned with position in the ranked list only.
Does Board have an easy way to indicate median? In effect the 75th percentile is the median of the values above the median of all of the values.
The term I'm asking about is described here:
The generic term is quantile.
Regards,
Pete
0 

You may have a look at the entire library of the available NEXEL formulas and syntax here
https://community.board.com/docs/DOC1241nexelcompleteformulaelibrary#comment1151
Cheers, Diego
1 
Thank you this looks promising. I'll look into it. Ultimately I need to get a result which uses the percentile value back into Board as a dimension: such as "fixed blades" is 50th percentile. Is the Nexcel layer on a screen available for this kind of thing?
(Mobile)
Peter DeGregorio
Information Technology
ITW Global Brands
Hartford CT
2 
Hi,
you can write back the result of the nexel layer to an cube or also can set an Relationship using nexel (Nexel ).
But keep in mind, that the Percentile is depending on the number of selected elements, so it might be better, to write back those values back to an cube (structured on an user dimension), cause otherwise the solution wouldn't be multi user ready
regards
Björn
3 
Hello, I found the Nexel formula very useful, but it works till there are some dozen, may be some hundred lines. I tried to use it to calculate the median of all orders, 2030.000 lines and it doesn't work
Any suggestion?
Thanks
Cristiano
0
Categories
 All Categories
 1.8K Forums
 1.7K Platform
 113 Academy
 286 Resources
 3 Community Captains
 1 About Community Captains
 1 Meet the Community Captains
 1 Topics & Thought Starters
 Board Manual
 50 Best Practices
 43 HowTo Guides
 25 Board Advocacy Program
 161 Blog
 4 Groups Hub
 4 About Groups
 New Community Members
 DACH
 Japan
 Academy
 2 Board Academy
 7 ILT/VILT Course Catalogue
 13 eLearning Course Catalogue
 4 Academy Forum
 1.1K Idea Exchange
 311 Partner Hub
 2 Solution Sales Toolkits
 92 Support
 14 FAQ's
 Customer Support Portal
 54 Support Articles
 BEAP