Add Filter to Reports

Users can refine the data set returned within a report by using the Filter tools within the Design View. #results #InputControls

Updated over a week ago

Users can refine the data set returned within a report by using the Filter tools within the Design View.

Three Filter Tools:

Applied to a single report tab. They are similar to Query Filters but that you cannot prompt on them.

A flexible way to allow end Users to filter reports. Unlike Simple Filters, the look, feel, and operation of these filters can be customized. Input Controls can be applied to individual report pages or the whole document.

Allows end Users running the report to narrow a report for one value in a Dimension at a time.

Filter bars will be depreciated in future versions of Results. We suggest moving to Input Controls.


Report Filters (Simple Filters):

These filters will be depreciated in future versions of Results. We suggest moving to Input Controls.

Step 1 – Click the "Analysis" tab.

Step 2 – Click the "Filters" sub-tab.

Step 3 – Click the Report "Filter" icon.

Step 4 – The Report Filter window will open. Select the section of the report where the filter should be applied. Report Filters can apply to a section, a table, or a report tab.
Step 5 – To define the filter, click "Add Filter" in the upper right corner.
Step 6 – Select the appropriate objects to apply as a filter. To select more then one object at a time, hold CTRL.
Step 7 – Click OK.
Step 8 – Select the properties for the filter(s) and click OK.
Step 9 – To remove the report filter, click the area where the filter is applied. Click Remove Filter or Remove All.


Input Controls

  1. Click the "Analysis" tab

  2. Click the "Filters" sub-tab

  3. Click "Input Controls"

  4. Choose the Object to filter on. Click Next.

  5. Choose the control and its associated properties


  6. Select the desired option for User selection:

    1. Simple Selection: Allows Users to choose one value

    2. Multiple Selection: Allows Users to choose several values

    3. Values can appear as radio buttons, check boxes, a list, numbers on a sliding scale, etc.

  7. Select the part of the report where the filter will apply. This section is similar to the mapping area

  8. Once the filter is applied, end Users can modify the information displayed in the report by operating the Input Control on the left side navigation options.


Filter Bar (Simple Filter)

Step 1 – Click the "Analysis" tab.

Step 2 – Click the "Interact" sub-tab.

Step 3 – Click the "Filter Bar" icon.

Step 4 – Click the simple filter icon to add filters.

Step 5 – To remove a simple filter, click the filter within the filter bar and select (Remove).

Filter bars will be depreciated in future versions of Results. We suggest moving to Input Controls.

Did this answer your question?