Navigate to URL
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'.
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.
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.
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).
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.
- The Filter Value Caption and Placeholder As URL functionality also applies to Drill Down and Hover Over (pop-up) interactions.