Filter Issue: Employee Count Greater Than 50 Showing No Results

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

35 comments

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?
AJ C.
·
·
FINAL - Validated email is not empty And Ad Visits Check - is checked
AJ C.
·
·
Starting from row 1250
Bruno R.
·
·
Hi Alexander, thanks for providing additional context! Could you clarify the purpose of the filter? Are you trying to filter companies with a headcount above 50, exclude companies where the final validated email is empty, or exclude companies where the ad visits check is not selected? I’m not entirely sure what logic you're aiming to implement here. Both filters seem to be working individually, does the issue come up when you merge them?
AJ C.
·
·
This one is separate from headcount - headcount filter was already solved when you made the other view for me
AJ C.
·
·
Just all companies (after row 1250) with Ad Visit check selected
AJ C.
·
·
That's the view I need
AJ C.
·
·
And it's working for you but not on my end
AJ C.
·
·
still
AJ C.
·
·
I tried it individually too, still nope
AJ C.
·
·
Bruno R. still not working
Bo (.
·
·
Hey! 👋 Just to clear things up - if you're trying to apply the Ad Visit filter after row 1250, that's not quite how our filters work. The filter will always apply to the whole dataset, not just rows after a certain point. Could you tell me what you're trying to achieve here? I bet there's a better way to get the results you're looking for! 😊
AJ C.
·
·
I see!
AJ C.
·
·
What I'm trying to do is export the people who have Ad Visit check selected. I was only saying to export after row 1250, becuase I only ran the enrichment for rows after 1250 (I have already exported the first 1250 leads and used for a different campaign so I don't want to enrich them anymore) Although, I suppose it doesn't matter if the filter looks at every row, because there would only be a check-box marked true, if the enrichment ran
AJ C.
·
·
So it should be all good
AJ C.
·
·
But still having the problem where I'm getting 0 rows to show, when I apply the filter "Ad Visit - Is Checked"
AJ C.
·
·
Nothing returns, meanwhile there's 400 or so rows where that is true.
Bo (.
·
·
It looks like we've got a bug on our hands - I've escalated this over to our engineering team and we'll let you know as soon as we know more!
AJ C.
·
·
okay thank you
AJ C.
·
·
I solved it anyway by just doing the filtering in google sheets but yes let me know in case it happens with other filters
Bo (.
·
·
Will do Alexander. Great thinking fixing this, will let you know as soon as I know more.