Creating an Interaction

Create a Filter Interaction

You can create interactions using the interactions view or the Interactions tab in the right pane.

The following objects that are imported from the explorer can be the source of a filter interaction:

Box plots
Heat maps with a relational category measure
Forecast plots
Geo maps

Imported correlation matrices, histograms, scatter plots with fit lines, heat maps without a selectable relational category measure, and box plots without a selectable relational category measure cannot be the source of an interaction. Hierarchy data items are not supported for interactions.

Note: You cannot create interactions from list tables, bubble plots, and scatter plots that use detail data. However, a list table that uses detail data can be the target of an interaction.

Note: Scatter plots cannot be the source of an interaction.

Note: Bubble plots can be the source of an interaction only if they have a Grouping role assigned.

To create a filter interaction using the interactions view:

Add the report objects that you want to use to the canvas. For example, you might have a bar chart, a line chart, and a list table.
Click Interactions View on the Interactions tab to switch to the interactions view. You can also select View Show Interactions.
In the interactions view, draw a connection between the source and target report objects. When you have created an interaction, the is displayed between the report objects. Here is an example of an interaction between a bar chart (the source) and a list table (the target):

Note: The source and target of an interaction should be based on the same data source. If you have multiple data sources, you are prompted to map the data sources to create the interaction. For more information, see Map Data Sources.
Right-click . Then, select Interaction TypeFilter.
(Optional) Clear the Show derived interactions check box. (Derived interactions are represented by dashed lines in the Interactions View.)
(Optional) Add other filter interactions.
Click Close. The new interaction (or interactions) appears on the Interactions tab in the right pane.

The following example shows the Interactions tab for the filtering example shown in A Filtering Example with a Bar Chart, a Line Chart, and a List Table.

Select data in the source report object to filter data in the target report object (or objects). In the following example, the promotional product line was selected in the bar chart. Simultaneously, the line chart and the list table show the same filter.

A Filtering Example with a Bar Chart, a Line Chart, and a List Table

Clicking on another selection applies the filter based on your new selection. For example, in the report above, you can click on the game product line to change the filter. An icon is added to the report object that is filtered.

Here is the line chart that was used in the previous example. The incoming filter icon appears above the report object when it is selected in the canvas. Click the Filter button

to get details about the filter that has been applied. Click Details to find out more about the filter. The Visual Element Filters window is displayed. It shows the exact query that was sent to the server.

Example of a Report Object with an Incoming Filter

To clear the selection and reset the filter (or filters), press Ctrl+click while viewing the original report object.

To create an interaction using the New button on the Interactions tab:

Select a report object in the canvas. For example, you might have a bar chart.
Select the Interactions tab.
Click New, and then select Interaction. The Edit Interaction window is displayed.
In the Edit Interaction window, select the report object that you want to use as the source of a filter or brush interaction. For example, if your report has a bar chart, and you want it to filter a line chart, the first line should read Bar Chart 1 filters List Table 1.

The Edit Interaction window disables options for filter or brush interactions if they are not possible.
When you are finished working with interactions, click OK. The new interaction is displayed in the Interactions tab.

Create a Data Brushing Interaction

The following objects that are imported from the explorer cannot be the source of a brush interaction:

Box plots
Heat maps with a relational category measure
Forecast plots
Geo maps

To create an interaction using data brushing:

Add the report objects that you want to use to the canvas. For example, you might have a bar chart, a line chart, and a list table.
Select the Interactions tab.
Click Interactions View on the Interactions tab to switch to the interactions view. You can also select View Show Interactions.
In the interactions view, draw a connection between the source and target report objects. When you have created an interaction, the is displayed between the report objects.

Note: The source and target of a data brushing interaction should be based on the same data source. If you have multiple data sources, you are prompted to map the data sources to create the interaction. For more information, see Map Data Sources.
Right-click . Then, select Interaction TypeBrush.

The filter icon changes to .
Click Close. The new interaction (or interactions) appears on Interactions tab in the right pane.

Select data in the source report object to brush data in the target report object (or objects). In the following example, the stuffed animal product line was selected in the bar chart. Simultaneously, the line chart and the crosstab highlight the same data.

A Data Brushing Example with a Bar Chart, a Line Chart, and a List Table

Note: If a graph contains a frequency measure, then a crosshatch pattern indicates when it is selected or brushed.

The brush interaction between controls behaves differently than a brush interaction between tables and graphs. When there is a brush interaction between controls, instead of highlighting or selecting the values in the other control, the values that match are moved to the top of the control, and the values that do not match are grayed out. If a frequency data item exists, then the frequency value is updated.

Here is an example of a report on cars with three list controls:

Three List Controls with Brush Interactions

The first list contains three countries listed as the Origin. The second list contains six types of vehicles. The third list contains 38 car manufacturing companies. There is a brush interaction between the first list and the second list. There is a second brush interaction between the second list and the third list. Look at the values in the second list.

Example: Three List Controls in a Report

In step 1, the user has selected Europe as the country of Origin in the first list. Notice the changes in the second list. Hybrid and Truck are grayed out, and their frequency values have both changed to 0. In the third list, all of the car manufacturers that are not located in Europe are grayed out, and their frequency values have all changed to 0.

Example: Three List Controls in a Report with One Brush Interaction

In step 2, the user has selected Porsche as the car manufacturing company in the third list. Notice the changes in the second list. Hybrid, Sedan, Truck, and Wagon are grayed out, and their frequency values have all changed to 0.

Example: Three List Controls in a Report with Two Brush Interactions

Map Data Sources

The source and target of an interaction or link should be based on the same data source. You might be prompted to map data sources so that an interaction or link works properly in these situations:

When you try to create an interaction or link between a report object that uses one data source and another report object that uses a different data source
When you try to create a link between a report object that uses one data source and a report section that uses a different data source
When you try to create a link between a report object that uses one data source and a report that uses a different data source

To map data sources using the Map Data Sources window:

Use the Source drop-down list to select a column from the first data source.
Use the Target drop-down list to select a corresponding column from the second data source.

Here is an example of the Map Data Sources window for an interaction between two list tables that have different data sources:

For section links, you are not required to map the data sources. If you choose not to map the data sources, then the filters are not carried over. For more information, see Create a Link to One or More Sections in a Report.

Here is an example of the Create Section Link window with the map data sources information.
(Optional) Map additional data items. Click . A new row is displayed in the Map Data Sources window.
The lower half of the window shows you how the mappings are applied to the objects shown in the Source and Target relationship. Depending on the interaction or link, you might need to map additional Source and Target objects.
Click OK.