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.

How to calculate the mode for crowdsourced data?

Topic Labels: Formulas
181 1
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

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.