Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Mar 16, 2022 10:53 AM
Hi everyone,
I’m trying to figure out how to calculate the Mode (ie. the most frequently occurring number in a series). I need this for the purposes of turning crowdsourced data into something useful. For example, if I ask 10 employees of one company how many days of holiday they get a year, I want to return the value most frequently cited, not the average (mean) because that would be inaccurate.
In google sheets, it’s simply the function: MODE() but Airtable doesn’t have this.
Does anybody know how I might do this?
Jan 25, 2023 12:34 PM - edited Jan 25, 2023 01:14 PM
Bump. I too am wondering how to calculate mode since Airtable doesn't have a MODE() formula.
Edit: I asked a mathematics sub-forum how to calculate MODE using only +, −, ÷, ×, etc. I'll post here if I get an answer.