There are three ways that tabular (table) data can be filtered in Nova. We’ll see how they’re used in this article.
Filtering the table
If you have a large report Nova might indicate that there are too many results to display them, like this:
Other times you might just want a subset of users, for example if you want users beginning with the letter D.
In these situations you can filter the data, by:
- Clicking on ‘Add Filter’
- Choosing an appropriate field, like ‘Display Name’.
- Choosing an operator like ‘Contains’ or ‘Begins with’
- Entering the filter or search criteria.
- Clicking on ‘Preview Section’ to review your results.
You can see how to do it in this short video:
You can also do a global filter on a report to provide some helpful filtering to a user of the report.
To do this you:
- Click ‘Add report filters’ at the top of the report
- Click ‘Add filter’
- Give the filter a name.
- Click on ‘Add condition’
- Enter the filter criteria, for example ‘Display Name’, ‘contains’, ‘Dan’.
Now at the top of the report you’ll see the filter, and it can be applied at any time, and can also be disabled at any time; giving you extra flexibility.
Here’s how a simple report might be customized. Not filtered:
Searching / filtering afterwards
On table data in Nova you’ll also see filter/search boxes at the top of each column, so, on an existing report you can quickly filter a working report to show just people in the Sales department for example:
And you can do that on any of the fields, or combine them to give you everyone in Sales in a particular country/region.