Skip to main content

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

  • December 21, 2018
  • 1 reply
  • 47 views

Forum|alt.badge.img+5

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

Karlstens
Forum|alt.badge.img+24
  • Brainy
  • 602 replies
  • January 3, 2023

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?