Rollup most common value?

2378 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two tables, one with products and one with parts of the product. On the parts table, I include a team member who's responsible for that part. Sometimes the same team member is responsible for all the parts, and sometimes the responsibilities are split.

In the products table, I'd like to summarize the team member who's most responsible for the product, who'd be the person assigned to the most product parts. I can't figure out a way to do a rollup that shows the most common value of the linked parts, though. Is there a way to do that?

1 Reply 1

Hmm, off the top of my head I think you'd have to do this with an automation that runs a script every time a `Product`'s `Part` list gets updated I'm afraid

Hopefully someone else has an idea for a non-script solution