Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

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

Filter Issue: Employee Count Greater Than 50 Showing No Results

·Nov 26, 2024 03:13 PM·

Applied a filter to my table and it doesn't work - "Employee count greater then 50", and it's showing no results, but there are plenty of rows with employee count greater then 50. The column is a # column too. And I tried a different filter for showing results when the checkbox is marked TRUE. Also, not working, something seems to be broken with filters today https://app.clay.com/workspaces/310596/tables/t_ERNStg5dr89T/views/gv_UZPxt9VpEtoC

37 comments

· Sorted by Oldest

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 T.
·
·
AJ C. try removing the final validated email filter as well to isolate this variable?
AJ C.
·
·
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 C.
·
·
AJ C.
·
·
Just tried it anyways - still returns no rows
Jacob T.
·
·
AJ C. might be a bug, although filters are working properly for me
Bruno R.
·
·
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 C.
·
·
thanks for the quick reply
AJ C.
·
·
Yes, your custom view works
AJ C.
·
·
but when I re create the same filter it doesn't
AJ C.
·
·
Bruno R. 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 C.
·
·
Bruno R.
·
·
Can you specify what group of filters you're using here so I can attempt to reproduce the issue on my end?
AJ C.
·
·
yeah I sent a screenshot just now do you see it?