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!