I was wondering if there is a way to do a percentile calculation in Airtable.
Basically I’m trying to determine salary percentiles (in my case let’s say 75th percentile).
So say I have a column of salaries in a “Positions” table with 25 rows (mine has way more, but for the sake of simplicity).
I figured out that I can do the linked record trick to get all the values pulled into a single cell in another table, call it “Summary”. So i would use a lookup field to pull all 25 salaries from “Positions” into an array in the other table. I can then do a count of the number of values in that array. Then in theory I would multiply that count times my percentile (0.75 in my example), and round the result up to an integer, n. Then it’s a matter of finding that nth value in the array. BUT the array isn’t in order, so without being able to sort the array in ascending order, I can’t actually do the percentile.
Anyone have any experience with this type of problem and a possible solution? I’m out of ideas at this point.