Filter Issue: Employee Count Greater Than 50 Showing No Results | Clay

Filter Issue: Employee Count Greater Than 50 Showing No Results | Clay

Channeled
APP
·
·
When filtering number columns in Clay, make sure to follow these steps: 1. Click "Filter" above the table 2. Select your employee count column 3. Choose "greater than" as the operator 4. Enter the number 50 (without any commas, spaces, or other characters)If you're still not seeing results, check that the employee count values in your column are actually stored as numbers rather than text. Numbers stored as text won't work with numerical comparisons. Source: Hide, Re-order, Sort, Filter, Merge Columns
Jacob Tuwiner (Clay to HubSpot Integration as a Service)
·
·
AJ Cassata try removing the final validated email filter as well to isolate this variable?
AJ Cassata
·
·
Thanks - there's 100s of rows where this would still be true and it has a final validated email
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
AJ Cassata
·
·
Loading attachments
AJ Cassata
·
·
Just tried it anyways - still returns no rows
Jacob Tuwiner (Clay to HubSpot Integration as a Service)
·
·
AJ Cassata might be a bug, although filters are working properly for me
Bruno (Clay)
·
·
Hi Alexander, thanks for reaching out. Can you confirm that this is the filter you're applying here? https://downloads.intercomcdn.com/i/o/w28k1kwz/1266440239/ca43cff1ab39b56854286a6ed6c0/CleanShot+2024-11-26+at+10_18_12%402x.png?expires=1732635900&signature=88dc2afba53d1101593c5290bf15e2ceada3141680306efd395696d193f7ddc8&req=dSIhEM16nYNcUPMW1HO4zdf58n8yk%2BKP9Ra7E6AXEgT4jwDtRmaFTS7e1Lwc%0A1Xih%0A I created a view titled "clay support view" where I was able to filter by instances where the employee count was greater than 50, and the filter seems to be working on my end! Can you test the view here and see if the same is reflected on your end?
AJ Cassata
·
·
thanks for the quick reply
AJ Cassata
·
·
Yes, your custom view works
AJ Cassata
·
·
but when I re create the same filter it doesn't
AJ Cassata
·
·
Bruno (Clay) Would you mind creating another view I can use, And have it only starting from rows 1250+ onwards, till the end of the list
AJ Cassata
·
·
Loading attachments
Bruno (Clay)
·
·
Can you specify what group of filters you're using here so I can attempt to reproduce the issue on my end?
AJ Cassata
·
·
yeah I sent a screenshot just now do you see it?