Maximum count of a non-numerical linked value

Topic Labels: Formulas
933 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have an Airtable with 3 tables: a list of readers, a list of books, and a list of genres. The books table has a lookup relationship with both genre and readers. Each book can have multiple genres. I’m trying to display the reader’s favorite genre based on the books they have read.

In other words, of the books the user has read, which genre (or genres in the case of a tie) occur(s) the most number of times?

Here’s how I tried approaching the problem: Make a hidden lookup or rollup field that aggregates all of the genres from the linked books then find the genre that occurs the most number of times. However, I’m not sure how to do that second step.

Is this possible in Airtable? I would appreciate any suggestions! :slightly_smiling_face:

1 Reply 1
4 - Data Explorer
4 - Data Explorer

I find the easiest way to find the most is to convert relationship counts to numbers, which would mean adding a count field on genre that counts the number of linked books. Then you can either sort by number or write a formula field based on it.