The MODE aggregation a lookup function is one of my favorite hacks, and this is a great use-case for it.
I’ve documented some of the use-cases and solutions in this thread awhile back, and @thorsten.langner added a great alternative approach as well.
Here’s a quick video I made to show what this looks like when you try to build it in your instance:
If folks have other approaches or use-cases for the MODE aggregation I’d love to hear them!