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

Zaque · 2020-09-09T05:49:14.060Z

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?

maxime.garcia · 2020-09-09T07:27:41.637Z

Hi Zaque,

Hope my screenshot will help you

Sans titre776×338 23.8 KB

Zaque · 2020-09-10T01:01:32.101Z

@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.