Using interactions


In Dundas BI, you can set up actions or interactions on any visualization, filter, or component, or view such as a dashboard.

You can set up common interactions from the toolbar or context menu, and any number of other action combinations using the Properties window.

Related video: Interactions

1. Actions

For every event that can occur for a dashboard or other view, or one of its elements, there is a list of actions you can add to that will run when that event occurs. The available lists of actions differ between the various types of views and their elements. Typical actions lists include Click and Hover, and there are many that are specific to a particular element, such as Selection Changed on a Drop Down List or No Data on a data visualization.

There are several types of actions available that you can add:

  1. Navigate – navigates to a new page
  2. Hover Over/Pop-up – displays a pop-up of another view such as a dashboard
  3. Drill Down – goes one level down in the hierarchy and filters to the selected data
  4. Filter – filters to the selected data
  5. Expand/Collapse – expands a hierarchy member to view its values from one level down, or collapses them up
  6. Change Layer – shows or hides layers
  7. Toggle Template Cell – expands or collapses a cell in a dashboard's template grid
  8. Data Input – appends data to a Data Input transform in a data cube (not available on data visualizations)
  9. Script – executes the provided JavaScript code (only available from the Properties window)

List of interactions in the toolbar
List of interactions in the toolbar

2. Creating an interaction

To quickly create an interaction for the element that's selected, choose Set Up Interactions in the toolbar and choose an option. This will automatically add an action to the default actions list (default event) and open its dialog for you to configure or confirm its settings.

The following table shows the default action associations:

Element Drill Down Navigate Filter Change Layer Toggle Template Cell Data Input Hover Over/Pop-Up
Data visualizations Click Hover
Filters Value Changed
Radio Button List Selection Changed
Drop Down List
Timer Timer Interval Tick
Slider component Changed

Actions can be added to actions lists other than the default by creating them in the Properties window. As an example, you can make a pop-up appear when a data point is clicked, rather than when the mouse hovers over it.

The following steps walk through how to add an action to an actions list of your choice:

Add a visualization or component and select it.

Add and select a visualization or component
Add and select a visualization or component

Go to the Properties window, and in the Main tab scroll down to the Actions category.

Go the Actions category
Go the Actions category

Expand the list of actions you're interested in, such as the Click actions.

Expanding the Click actions list
Expanding the Click actions list

Click the menu icon on the right, and choose a type of action. We will select Pop-up.

Selecting the Pop-up option
Selecting the Pop-up option

Configure the interaction.

Configure the pop-up
Configure the pop-up

3. Configuring an interaction

After an action is created, its dialog appears. In many cases, it will set itself up automatically and you can immediately click the submit button at the bottom to close it.

There are several options to configure how the interaction is triggered. Most options are specific to the type of interaction; for examples, see the relevant articles linked to above. The options Name and Friendly Name are available for every type of action, to optionally label the action in a meaningful way.

3.1. Bound visual

The Bound Visual option causes the action to occur only on the indicated part of that control or visualization. 

The Bound Visual option
The Bound Visual option

Many visualizations allow you to limit an interaction to a specific area, such as a column in a table or one series of data points in a chart.

Checkboxes can be in one of two states: Checked, and Unchecked. You can bind an interaction to either state. For example, when the checkbox is Checked, a layer is shown.

Drop down lists and Radio buttons have items that you add yourself in the Properties window. You can bind interactions so that they are only triggered when a particular item is selected, or for each of its items. For example, a pop-up appears when the second of three radio buttons is selected.

To use a filter in this way instead of as a regular filter, check its Manual Items property. For example, you can add items to a Checkbox List filter and set up an action for each item.

This means you will be using manually-added items instead of any connected parameter.

Select the Manual Items property of a checkbox filter
Select the Manual Items property of a checkbox filter

3.2. Set up parameters

Many actions involve choosing what data should be passed to a parameter (e.g., what data to filter by.)

When setting up a filter or drill down interaction, Dundas BI will automatically make a choice for you based on compatible data on the current dashboard or view, but you can confirm or change this setting. Navigate and hover over/pop-up interactions require setting up the parameters if you want the other dashboard or view to be filtered.

To set these up, click Set up parameters in the interaction dialog.

Confirm or edit the parameter mappings
Confirm or edit the parameter mappings

Under Source, choose what value should be passed to a parameter. To pass values from multiple hierarchies, click the Add new mapping button to add multiple mappings, one for each hierarchy.

Under Target, choose a parameter to pass that hierarchy's value to. Dundas BI will automatically generate a parameter for a filter or drill down interaction connected to compatible hierarchies, or you can choose your own parameter. You can create parameters or change what the parameter is connected to in the Parameters window.

For a walkthrough on setting up parameters, see the relevant articles linked to above.

4. See Also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri