Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

3895 1
cancel
Showing results for 
Search instead for 
Did you mean: 
S_Steketee
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?