View Filters

Narrow report results by applying a View filter to the report. The View filter can include one or more filtering conditions that restrict the data displayed in the original report. Unlike the report filter, once the View filter is applied it does not retrieve data from the data source. Instead, a View filter restricts data based only on the report results already displayed on the screen.

 

Create a view filter by qualifying on any attribute or metric on a report. While attribute and metric qualifications both restrict the data displayed on the report, they are both created and defined in slightly different ways.

To filter data displayed on a report using the View filter:

  1. Click the name of a report to execute it.

  2. From the Tools menu, select View Filter. This displays a View panel in the report.

  3. In the View filter panel, click Add Condition.

  4. From the Filter On drop-down list, select the object (attribute or metric) on which you want to base the filter.
    The following choices are available, depending on the type of object selected.

Qualify - choose whether to filter on the attribute's description (DESC) or ID form. Then, select a comparison operator such as Greater than. Enter a value in the field on the right to finish defining the filter condition.

        • To compare the attribute to another attribute, click the Attribute icon Compare Attribute icon. Then select another attribute to compare it to.
        • Qualify and are qualifying on a date-related attribute, either type the day in or select it from a calendar. Click the calendar icon next to the date field, then click on a date to select it.

Select - choose In List or Not in List to include or exclude items that appear in the Selected list. Then choose elements from the Available list and add them to the Selected list.

Use the Search for field to search for a particular attribute element.

  1. Click Apply to apply the new filter to the report.

Related Topics

Using correct and efficient search syntax

 

 

_____________________________