Spawning a dashboard that passes variables

This example uses a table component to create a list of cities with associated links. When a link is clicked, a new dashboard for that city is spawned. The new dashboard contains a value component that uses a variable to display the city name and country name. Although this example uses a table and value component, this concept can be used with other Klipfolio components.

Note: Use only one of the two scenarios.

  • Column: City with clickable city link
  • Column: Link with Click here ... link

To spawn a dashboard that passes variables, you have to perform the following actions:

  1. Create a new dashboard and know the dashboard ID.
  2. Create and configure a table with links.
  3. Create and configure a value component.

This example uses the following data set:

A B
Country City
Canada Vancouver
USA Boston
Germany Frankfurt

Step 1: Adding a new dashboard and locating the dashboard id

  1. Create a new dashboard. For more information, see Building dashboards.
  2. Optional: If you include curly brackets with the variable reference in the dashboard name, the dashboard will display a different city name. For example: Details {city}.
  3. Locate the dashboard id. For more information, see the DATASOURCE function.

The dashboard ID is similar to this one: 1234342342343242abec123

Step 2: Creating and configuring a summary table with hyperlinks

  1. Build a Table component. For more information, see the How to build Table components.
  2. From the component tree, select Klip, and type a Klip Title.
  3. From the component tree, select Column: Unnamed 1.
  4. At the Properties panel, enter a name for the Column Header. For example, City.
  5. At Format as, select Hyperlink.
  6. At Open link select the check box for Open link in current browser tab.
  7. Set up the formula for the hyperlink as follows

CONCAT(SLICE(@B:B;),"| #tab-1234342342343242abec123?param:city=",SLICE(@B:B;))

  1. From the component tree, select Column: Unnamed 2.
  2. At the Properties panel, enter a name for the Column Header. For example, Link.
  3. At Format as, select Hyperlink and for Show Label type, Click here...
  4. At Open link select the check box for Open link in current browser tab.
  5. Set up the formula for the hyperlink as follows

CONCAT("#tab-1234342342343242abec123?param:city=",SLICE(@B:B;))

  1. Click Save.
  2. Name the Klip.
  3. Click Finished.

Step 3: Creating and configuring a value component

  1. Select Build a New Klip.
  2. Select the Value Pair component.
  3. Select Use an existing data source from the library option and select your data source.
  4. From the component tree, select Klip, and type a Klip Title. For example, Details Klip One.
  5. From the component tree, select Primary Value.
  6. Click Save.
  7. Name the Klip.
  8. Click Finished.

SELECT( SLICE( @A:A; , start, end ) , ( SLICE ( @B:B; , start , end ) = $city ))

Note: You need to add the value component to the dashboard you created at the beginning of these instructions.