How to count the number of users that contain a list of items of count x?

Need help Database
1

Having issues with what seems like an easy to-do. Thanks for your help in advanced!

I have a list data type called Favorites added to my User data type.

I want to do a count of User where the count of Favorites = 3.

Is this possible?

I want to do: Search for User’s with a List Filter of Favorites = 3, but the only options it gives me are contains and is empty.

I’ve tried several alternative approaches, but keep getting stuck. Do I need an advanced filter?

image

2

Hi Zaque,

Hope my screenshot will help you

Sans titre
Sans titre776×338 23.8 KB

1 Like
3

@maxime.garcia

Thank you so much, this was a huge help! I see everyone talking about the efficiency issues with Advanced filters, but never had a need to use them until now. Really appreciate your taking the time to help me with that.