Mode function or formula (as in mean, median, mode)

3345 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there any formula or function available in AirTable that calculates the mode of the values in a series? I can see on a grouped view that I can choose to summarize each group by summary, average, median, min, max but I don’t see mode as an option and can’t find anything on this in support or here in this (wonderful!) community.

“Mode” is a calculation that returns the most frequently occurring value in a series.

Specifically, I am trying to highlight records with a value not equal to the mode of a series/group.

Thank you!

1 Reply 1

Hmm, working on a new base today, I struck this same problem. Where I had several dates, and I needed a Mode to grab the most common occurring date. Anyone have a formula solution for finding a mode?