Navigate to URL

Contents[Hide]

1. Overview

This article shows you how to set up a navigate interaction so that when a user clicks on a table cell, a URL is opened in another window and the caption of the cell is passed in the URL as part of a query string (or passed as the URL itself).

2. Create a dashboard

For this example, create a dashboard with a table visualization that displays two columns (OrderQty and Product). This table uses the option 'Display As Flat Table' instead of row headers.

Create the dashboard
Create the dashboard

3. Set up the navigate interaction

3.1. Filter Value Caption

Right-click (or long-tap) over the table visualization. From the menu, click Set Up Interactions. Then click Navigate.

In the setup dialog, set the Bound Visual to Column 2. This is so that the interaction fires only when a Product cell is clicked.

Set the Navigate dropdown to To a URL. Then set Open to In a new window.

In the URL field, enter the following: http://www.google.com/search?q=varProduct

Select the Filter Value Caption checkbox. This ensures that the caption of the filter value will be passed to the URL instead of the filter value (or unique name). A caption in this case refers to the text you see in a table cell, such as 'Bikes'.

Set up the navigate interaction
Set up the navigate interaction

Next, click Set up parameters. In the parameter mappings setup dialog, click Add new mapping.

In the SOURCE list, select Product (Filter Value).

In the TARGET list, type 'varProduct' as the placeholder text. At viewing time, this placeholder text in the URL will be replaced dynamically with the caption of the clicked table cell.

Set up the parameter mapping
Set up the parameter mapping

Switch to View mode and test the interaction by clicking on a cell in the Product column.

A new browser window or tab should be opened with the results of a Google search corresponding to the clicked cell.

Click Bikes cell to open a Google search for 'Bikes'
Click Bikes cell to open a Google search for 'Bikes'

3.2. Placeholder As URL

What if your filter value caption or unique name (i.e. your data) contains actual URL values (or partial URLs without the http:// prefix)? In this case, the navigation will fail because the placeholder value will be encoded as part of the eventual URL.

To prevent this encoding, select the Placeholder As URL checkbox (usually in addition to Filter Value Caption).

Use the Placeholder As URL option when your data consists of URLs
Use the Placeholder As URL option when your data consists of URLs

If your data contains full URLs, just enter the name of your placeholder in the URL field.

If your data contains partial URLs without the http prefix, enter http://myPlaceholder in the URL field, for example.

4. Notes

  • The Filter Value Caption and Placeholder As URL functionality also applies to Drill Down and Hover Over (pop-up) interactions.

5. 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: 7am-6pm, ET, Mon-Fri