In this article, we'll cover:
-
About Filters
-
Highlights
-
Access the Filtering Menu
-
Applying Filters
-
Use the search bar to quickly find the choices you'd like to filter
-
Select All
-
Quickly keep tabs on your filters
-
Filtering label fields
-
About Filters
Focus only on the data you want to see by hiding the data you don't. Filtering helps you show only the most important and relevant data to your stakeholders and hide the rest. Filtering is currently available for connected fields like Jira Status and Assignee, as well as Visor custom fields, such as drop-down fields.
Highlights
Access the Filtering Menu
There are two ways to access filtering. First, click the funnel icon in the toolbar. By clicking the funnel, the filtering menu will display all possible fields to be filtered.
The second way to access this menu is by clicking the header row of the field you'd like to filter, and then selecting "Filter Field" from the drop-down. By clicking in the field's header row, the filtering menu will automatically open the filtering options for that specific field.
Applying Filters
From the filtering menu, select the field you'd like to filter by, and then select the choices you'd like displayed. Your workbook will update in real-time for you and your colleagues as you make these selections.
Use the search bar to quickly find the choices you'd like to filter
If there are a lot of choices for the Field you are filtering, use the search feature to quickly find what you are looking for.
Select All
Using the Select All feature when creating a filter is different than having no filter at all. "Select All" displays all of the currently available choices within a field. This means that if more choices are added to that field at a later point in time, the newly added choices will not be included in the view. When you use the "Select All" feature, you are selecting to filter out any new choices as they arrive.
Quickly keep tabs on your filters
As you add filters to your workbook, a number will appear next to the filtering icon in the toolbar representing how many filters have been applied to that particular view.
You can also easily see if a filter has been applied to a specific field. A blue funnel icon will appear in the header row of all fields with active filters.
You can also quickly see which choices have been selected for each filter in the filter menu.
Filtering label fields
Filters for fields that contain multiple choices, such as Jira Labels are an "or" type filter. When selecting multiple choices, the filter will display records that contain either choice, not both choices.