User List filtering only members with <100% Profile Progress?

I created a field called "cb_requireddata" which displays the users' Profile Progress and missing fields in their profile. I then displayed that field in a User List, which works great. My problem is that I need to filter that User List by only members who are < 100%. Although I can display this field on the list...the filter options do not give me the option to select my field "cb_requireddata" field, or anything that seems related to the Profile Progress. I have tried to create an advanced filter using SQL WHERE, but my experience with that is very limited.

Any suggestions to filter that list so that it only returns users who do not have a complete profile?

Thanks!

Profile completeness from CB Progress Fields isn't stored in the database so you won't be able to filter on it. Easiest way to do that though is to add multiple OR filters to your userlist to check if any of your required fields is empty. You will have to use an Advanced filter, which lets you directly add to the query WHERE statement. Example as follows.

Filters
Advanced
This should check if cb_field1 or cb_field2 is an empty string and display all users with fields matching those 2 if either are empty. Your query would of course be dependent on what type of field you're checking against.

Outstanding, thanks!