Filter rows in another table and give average in new table

1

Hello,

I didn’t find the exact solution to my problem on the community. So here I am.

I converted a select list into a table. And I want to know the average rating for each item (of the original select list). Here is a dummy doc to illustrate the situation : https://coda.io/d/Books_dnmspB5GOle

image
image508×644 28.6 KB

I tried several formulas (Filter, Contains, etc.) but nothing gave me the right result. For example, I tried : Books.Filter(Categories.Contains(thisRow.Categories)).Average(Books.Rating)
The “best” result I have so far is the same average rating for every row, which is not possible.

Thank you for your help :pray:

1 Like
2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.