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.Īnyone have any experience with this type of problem and a possible solution? I’m out of ideas at this point. Then it’s a matter of finding that nth value in the array. It’s created to provide a framework for building almost any kind of system imaginable, by giving ultimate ability to be customized according to an individual or company’s needs. 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. Airtable is an app that has positioned itself to be one part collaboration tool, one part flexible database. With Airtable, firms across a broad range of industries can easily and efficiently manage data as well as build scalable, flexible solutions. I can then do a count of the number of values in that array. Size 51 to 200 employees Salary - Airtable is a cloud-based software company that provides a collaboration platform and productivity tools for businesses to organize and manage data. So i would use a lookup field to pull all 25 salaries from “Positions” into an array in the other table. 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”. Based on 2 salaries posted anonymously by Airtable Head Of It employees in Simréab. ![]() 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). Average salary for Airtable Head Of It in Simréab: US194,949. I was wondering if there is a way to do a percentile calculation in Airtable.īasically I’m trying to determine salary percentiles (in my case let’s say 75th percentile).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |