Navigate to URL

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.

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'.

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).