Document toolboxDocument toolbox

Filter criteria

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)


Use the Business Users Guide to create workbooks and worksheets to organize your data. 

Criteria include the top and bottom values, list (or text) criteria, and numeric criteria. When you use multiple criteria, you can choose whether to use And or Or to relate the filters to each other. You can also set parenthesis around the criteria to create more complex filters.

  • TopN

  • BottomN

  • List criteria: Is, is not, starts with, starts with (match case), contains, contains (match case), ends with, ends with (match case), is not in the list, is in the list, is blank, is not blank, is in the top, is in the bottom.

  • Numeric criteria: equal to, less than, less than, or equal to, greater than, greater than or equal to, is in between.

  • Date criteria: Is, is not, is in the list, is not in the list, is after, is before, is before or equal to, is after or equal to, is between, is in last, is in next, is in this, is to date, is in the top, is in the bottom.

Note

You cannot modify the criteria in simple and complex filters (such as Cohort and Contextual TopN) if editing is not allowed from the Sheet and Filter Widget.





Copyright Kyvos, Inc. All rights reserved.