
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2018 11:17 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 03, 2023 03:17 PM
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?
