Clay Icon

Understanding Filter Rule Limitations in Data Columns

ยท
ยท

hey there, I'm curious why certain filter rules like 'greater than' or 'greater than or equal to' are only available on certain columns. I used to be able to sort employee count, for example, by employee count is 'greater than' 5 and 'less than or equal to' 20.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Different filter options are available based on the type of data in each column. For number columns, you can use comparison operators like 'equal to', 'not equal to', 'greater than', 'greater than or equal to', 'less than', 'less than or equal to', 'is empty', and 'is not empty'. Text columns have different options like 'equal to', 'not equal to', 'contains', 'does not contain', 'is empty', and 'is not empty'. Source: Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of David D.
    David D.
    ยท
    ยท

    thanks, Clay Bot! that was it.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You're welcome! I'm glad I could assist you. I'm here if you need any further help.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi David D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: