Applying filters

Applying filters


When you work with data in rows and columns—for example, datasets, matrices, transcripts or the event log—you can use filters to see a subset of the information.

What do you want to do?


 


Understand filtering

Filters can make information (such as datasets, transcripts and matrices) easier to work with. You can display only the rows that meet the criteria you specify and hide everything else. Working with a smaller set of data can make it easier to code, annotate or link. Filtering does not change your data in any way and you can easily clear a filter to see all of the data again.

You can only apply filters to columns or rows that display a filter icon ui_filter.gif . The filter icon changes to red ui_filter_red.gif when the data has been filtered.

The Status bar also shows whether the information in the Detail View is filtered ui_status_bar_filtered_icon.gif or unfiltered ui_status_bar_unfiltered_icon.gif.

NOTE

ic_top_of_page.gifTop of Page

Create a filter

  1. Select a column that displays the filter icon.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Filter Column.

rn_layout_sortfilter.gif

The dialog box opens.

Shortcut You can also click the filter icon ui_filter.gif to create a filter.

  1. Use the following steps to define the filter:

cn_filter_dialog.gif

a Select Show or Hide—do you want to show or hide the rows that match the criteria?

b Select the type of filter—do you want to filter anything  that 'equals' or 'contains' the specified text or is 'greater than' a specified value?

c Enter or select the criteria that you want to filter on.

  1. Click OK to apply the filter.

ic_top_of_page.gifTop of Page

Filter text

You can filter rows based on the text they contain—for example, show only rows that contain the text ipsum:

cn_filters.gif

There are various other types of text filters that you can create, for example:

ic_top_of_page.gifTop of Page

Filter numbers

You can filter rows based on the numbers they contain—for example:

ic_top_of_page.gifTop of Page

Filter dates and times

You can filter rows based on the dates and times they contain—for example:

ic_top_of_page.gifTop of Page

Filter for blanks and non-blanks

You can filter rows by showing or hiding rows that contain empty cells. For example, you could filter a transcript to see only the timespans that have recorded content.

ic_top_of_page.gifTop of Page

Filter events in the project event log

When working in the project event log, you can filter the events based on the type of event. For example you could

More than one column in the project event log can have a filter—for example, you could show only modifications to the project after 05/07/2010.

 ic_top_of_page.gifTop of Page

Apply multiple filters

You can apply filters on more than one column. As each additional column is filtered, the number of rows is further reduced.

NOTE Multiple filters cannot be applied to matrices.

ic_top_of_page.gifTop of Page

Clear a filter

  1. Select the column that contains the filter you want to clear.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Clear Filter on Column.

rn_layout_sortfilter.gif

The selected filter is cleared.

Shortcut Click filter icon ui_filter_red.gif, then select the Clear Filter button on the dialog box.

NOTE To clear all filters, click Filter in the Sort & Filter group on the Layout tab, and then click Clear All Column Filters.

ic_top_of_page.gifTop of Page

Change a filter

  1. Select the column that contains the filter you want to change.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Filter Column.

rn_layout_sortfilter.gif

The dialog box opens.

  1. Make the changes to the filter.

  2. Click OK.

Shortcut Click the filter icon ui_filter_red.gif and make the changes to the filter.

ic_top_of_page.gifTop of Page