Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) 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. You can apply date filter to a worksheet using the calendar date or calculated date.

    • In the calculated date, you can set the first date, last date or set the custom date to apply filter to a worksheet.

      • First date: The initial or start date present in the data.

      • Last date: The end date present in the data.

      • Custom date: Enter number of days after or before the selected date criteria.

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.



  • No labels