Example: Using the Filter Exclusion Feature

As an example of the Filter Exclusion feature, use an Interactive Reporting document with three dashboards (Home, Sales, and Customers) and two results sets. One results set contains sales and service revenue information, and the other contains customer satisfaction survey data.

Set filters to apply to both results sets; for example, year, quarter, and customer type. Set other filters; for example, city, sales group, sales representative, and product type to apply only to sales information. And apply filters; for example, type of use and age only to the customer satisfaction data.

Ensure the dashboards display visualizations and information reflected in the results sets. For example, the Home dashboard displays revenue and satisfaction visualizations, the Sales section displays only revenue data, and the Customers dashboard displays only satisfaction information.

Using the Filter Exclusions properties frame, click Default to perform these actions:

*  To use the Filter Exclusions properties frame:

  1. In Interactive Reporting Studio, navigate to Filter Exclusions.

  2. From Filter drop-down setting, select an option to configure filter drop-down lists on dashboard frames and automatically assign filters to frames:

    • Add and remove filters from Filter drop-down lists—Automatically add filters that affect a dashboard, and remove filters that do not affect the frame (This option overwrites current filter configurations)

    • Remove excluded filters from Filter drop-down lists—Remove filters that do not affect the dashboard frame, and do not add filters that are not already added)

    • Do nothing to the Filter drop-down lists—Filter configurations are not touched and no automatic filter assignments are added

  3. To apply a selected Filter drop-down setting, click Default.

  4. From Dashboards, select a section manual exclusions to filters.

    Available Filters is populated.

  5. Optional: To view the section, click View button.

  6. To copy excluded filters from the selected section to memory, click Copy button.

  7. Optional: To paste excluded filters from memory into the selected section, click Paste button.

    Paste button is visible only if you have clicked Copy button.

  8. Move selected filters between Available Filters and Filters excluded from displays by clicking Next button and Back button.

  9. Perform an action:

    • To discard selected filter and reload the original settings, click Restore

    • To remove all entries, click Clear All

    • To remove selected filters, click Clear

    • To exclude the selected filters, click Apply