Rollup on different items without having a separate table

[Joe_Gabriele]

Situation:
User adds a receipt to a Receipts Table
AI pulls waiter from receipt
User rates the waiter

I do not have a separate table for each waiter
I do have a Vendor table which is related to the Receipts Table

On the Vendor Table, I created a Lookup to find all waiters referenced in the Receipt Table and then used a Unique elements to remove duplicate waiters.

Through a multi relation between all the unique waiters and the Receipts table I can find each waiter and all their “receipts” / ratings.

What I’d like to figure out is if its possible to get each unique waiter’s average rating though a Rollup and display them in some sort of an Array. Ultimately I would like to provide each waiter’s rating. I did a rollup over the multi-relation, but just got the average of all the waiters and their ratings combined, not their individual ratings.

This would be much easier / possible if I had a Waiter table, but its not a huge feature of the app, so I would like to avoid consuming lots of rows just for this one thing.

[Jeff_Hager]

I would do that in the receipts table. Create a relation linking the waiter column to itself. Then create a Rollup that uses the relation to calculate the average for each waiter.

[Joe_Gabriele]

Very nice! So their average rating will constantly be updated in the Receipt Table and I can just pull from that. Nice! Thank you

Any recommendation on how to display each waiter and their average rating in a list after removing duplicates?

Actually I found a prior answer that solves the above: Is there a way to filter duplicates from an inline list? - #14 by Jeff_Hager

[Jeff_Hager]

Yep, that’s exactly what I would have suggested.