How to calculate the mode for crowdsourced data?

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.