Filtering Repeating Group with field in relational database

Hi, I have a repeating group of cards with Data Source of Service Provider. Each Service Provider has a list of Reviews in a relational database called Review. I have a filter with a star rating that equates to a number value. I am trying to filter the Repeating Group of Service Providers with this star rating filter so that a user is able to filter each Service Provider based on their average star rating. I have tried multiple combinations in the advanced filter, and am just not able to get it right. Please help fellow bubblers.

Filter


The easiest way (as for me) is to store average rating in a separate field within Service Provider data type. You also will not need to use advanced filtering for it.

1 Like

Thanks @artemzheg !