Filtering Data in Optimized Design Mode

Use story and page filters to narrow the scope of your analysis.

Story filters allow you to apply filters for all charts in a story that are based on the same model. They are used for specific dimensions or measures and can apply to all components of a story.

Page filters are the same as story filters, but apply to only one page in a story.

You can also use linked filters, with advanced filter options.

Note

Page and story filters are enabled only after you have added at least one data source to your story.

A data source for a chart or table may prompt you to select members before data can be displayed. If the data source you select to create a chart or table requires variables to be set, a prompt will appear when you create the first chart or table that uses the datasource. After the variables are set, the information you provide will be used by all tables and charts that use the same datasource.

As you create your story, you may want certain information to be readily accessible, but not always displayed. Input controls allow you to do just this. They allow users to filter data, compare figures, and explore relationships directly from a story page.

You can use the following input controls:

• Dimension Input Controls: Use the dimension input control to change the dimension that is represented on a chart or table at view time.
• Measure Input Controls: Use the measure input control to change the measure that is represented on a chart or table at view time.

Watch this video to learn how to create Input Controls.

In chart-to-chart filtering, you have the option to add new tabs and set filters to jump from one page to another. For example, as shown in the figure Chart Component Hyperlink Filter, you can set a filter to jump to a detailed report for West US from a summary report.

If you select "Apply Selected dimension as filter", you will also have an option to enable the cascading filter. Selecting this option will pass your selected cell as a filter value to the detailed report.

Advanced filtering allows you to create story and page filters based on multiple dimensions by defining a set of logical conditions.

The dimensions used in advanced filtering can be filtered by using AND or OR conditions. These conditions can be set to include or exclude the data that satisfies the filter conditions.

The figure below illustrates an example where advanced filters have been used to return United States data for all years and overseas data only for 2018.

You can apply advanced filters by creating dimension tuples. A dimension tuple consists of a condition which contains a number of dimension filters. If the dimension members are different, the result will create an asymmetrical filter.

Currently, advanced filtering can be used with Story and Page filters.