How to Apply a Filter in Clay Table with Specific Value Threshold? | Clay

How to Apply a Filter in Clay Table with Specific Value Threshold?

Hello everyone, I have a rather simple question. I want to apply a filter in my Clay table of the type e.g. "Column X doesn't have errors AND its value is greater than 0". However, I only find the option to choose "does not have errors". When I try to filter with a specific value threshold in mind, I don't seem to find such option...

13 comments

Clay Team
APP
·
·
Hey hey, can you drop a link to your table?
Clay Team
APP
·
·
Your column is likely a text type and needs to be changed to a number to see the number operators:
177b9334-c21a-46aa-b8b0-15a2abffa258.png(58 kB)
Debora A.
·
·
Thanks for the attention! The solution you gave me seems to work for regular columns, but not for columns created through the use of a Claygent . I tried alternatively to change the output to "Yes", "No", or "Unknown", as my choice of numeric output was actually more coming from a background where I would code something to analize a csv file. Anyway, my natural outputs are yes, no and unknown and I changed the column to reflect that - but it still doesn't work with the filters. It is as if the filters didn't have access to the outputs of a Claygent-created column.
Matthew Q.
·
·
Can you drop a URL for the table?
Matthew Q.
·
·
You likely need to map out the result of the Claygent column
Matthew Q.
·
·
Then you can filter based on that result
Debora A.
·
·
Hi Matthew, thanks for this. This is the URL of the table: https://app.clay.com/workspaces/161800/tables/t_dcJFknitgRUh/views/gv_9khd4pJ1zWjC
Debora A.
·
·
I am now trying to figure out how to map out the result of the Claygent column onto another column
Debora A.
·
·
could you help me with that?
Clay Team
APP
·
·
Hey Debora, what column are you trying to map it to? You can expand one of the cells and hover over the value you want to map out and add it as a column. It will automatically do it for the entire column
7115f773-0c8e-4f93-aa5e-cb94d9f0adea.png(48 kB)
b1b42691-c474-4346-b587-e047ac97f60d.png(14 kB)
Debora A.
·
·
thanks, that solved the problem!
Debora A.
·
·
I have another issue: I need to share my Clay table with my collaborator and I don't seem to know how to do that. I tried just sharing my URL as I did here, but it was not possible for him to open the table using his Clay account
Matthew Q.
·
·
Hey Debora, is this person in the same clay workspace as yourself?