Filtering Issue with True/False Column in Clay Table | Clay

Filtering Issue with True/False Column in Clay Table

Hi Clay Team- quick question- here's the table https://app.clay.com/workspaces/507736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 want to filter on a column but do not get the right options in the filter box. It's a True/False column. Should be able to filter for true or false. Don't see the option in the column "ICP Company Hiring Guards"

5 comments

Channeled
APP
·
·
There could be a few reasons why you're unable to filter the "ICP Company Hiring Guards" True/False column: 1. Data format: Ensure the column contains proper True/False values. If it's not formatted correctly, filtering might not work as expected. 2. Table update: If you've recently added or modified this column, the table might not have refreshed. Try re-running the step that generated the data or duplicating the table with the updated source. 3. Filtering method: Make sure you're using the correct filtering method: • Click "Filter" above the table • Select the "ICP Company Hiring Guards" column • Choose "equal to" or "not equal to" • Enter "True" or "False" in the field If these steps don't resolve the issue, you might be experiencing a temporary front-end performance problem. Try clearing your cache and refreshing your screen. If the problem persists, click on "Talk to a person" for further assistance.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Sources | Documentation | Clay University
Adam G.
·
·
Hi Clay Team- quick question- here's the table https://app.clay.com/workspaces/507736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 want to filter on a column but do not get the right options in the filter box. It's a True/False column. Should be able to filter for true or false. Don't see the option in the column "ICP Company Hiring Guards" (edited) image.png
Bo (.
·
·
Hi Adam, The reason you're not getting the True/False filter options is because you're trying to filter based on the enrichment column itself. What you need to do is add the results as a separate column, and then you'll be able to filter on it properly. Currently, what you're seeing in the filter menu is just the filter for the enrichment process, not the actual data values.
1
Adam G.
·
·
All set. Thx
Channeled
APP
·
·