Able and willing to pay a consultant for this project:
I help writing a few scripts for an airtable base for calculating percentiles within a data set, rather than just average or median - ie 25th and 75th percentile. I need these to be able to recalculate whenever the data is filtered. This is possible in excel with a formula, but not in Airtable.
Secondly, I'd like to be able to integrate this percentile data into an interface - currently I am easily able to show median, average, total sum, total entries, etc. - so I'd like to add percentile calcs alongside these outputs.
If you're able to help out here, that'd be awesome. And if you're good, there are numerous other paid projects that I will hire you for.
I am Himanshi. I represent Ajackus, an official Airtable partner. We specialize in building customized solutions with Airtable as a database. We have helped startups and enterprises worldwide make the most of it.
We would love to help you with your scripting and integration requirements. Can we schedule a call to discuss this further?
This is a ChatGPT level problem, took me about 15 minutes to hash out. You may copy the solution script from here:
If you need these to run automatically, use the script module in an automation, and instead of choosing the tables, and fields, hardcode it in the script. GPT would easily help you here.
ChatGPT is decent at handling relatively complex scripts in Airtable. You might wanna try it.
You may reach out to me through the website if you need support with deploying this or any other complex workflow.
I have lengthy experience working with Airtable scripts to develop custom workflows and automations. Happy to have a call about how we can work together on the percentiles and calculations: you can book a time at your earliest convenience from my calendar: https://alessiomonino.com/contact