“Learn how to add a hyperlink to a search.”

You can add a hyperlink directly within a Search. Using the concat formula, you can create an external hyperlink, or link your Answer to another Pinboard.

To add an external hyperlink in a search, follow these steps:

  1. Start a new Search.
    Alternatively, choose to edit an existing Answer from a Pinboard.

  2. If the Answer shows a chart, switch to Table View. Switch to table view

  3. In the upper-right side of the table, click the More menu icon more options menu icon, and select Add formula.

Create a new formula in an answer

  1. Name your formula.
  2. Enter your formula, following the basic syntax:
    concat({caption}value{/caption}link)
    
  3. For a data set that does not contain properly formed urls, your formula should include the url in full.
    For example, to link from the Product Category column to a Google search, use the following syntax to reference the product category column, and a Google search using its values:
      concat("{caption}",product category ,"{/caption}","https://www.google.com/search?q=",product category)
    
  4. For a data set that contains properly formed urls, you can simplify the formula.
    For example, to link from the Fruit column to the url, use the following syntax to reference the two columns, fruit and url:
      concat("{caption}",fruit,"{/caption}",url)
    
  5. Click Save.

To add a hyperlink to another Pinboard, follow these steps:

  1. Start a new Search.
    Alternatively, choose to edit an existing Answer from a Pinboard.

  2. Choose the target Pinboard for the link.

  3. Open your target Pinboard and copy the web address.

  4. Within your Search, switch to Table View.

  5. In the upper-right side of the table, click the More menu icon more options menu icon and select Add formula.

Create a new formula in an answer

  1. Name your formula.

  2. Enter your formula, following the basic syntax:

    concat(“{caption}pinboard{/caption}http://<thoughtspot_server>:<port>/?<runtime filter>,column name)
    

    For example, the formula to link between a search on fruit sales and a Pinboard based on the same data with url https://.com/#/pinboard/e510f946-f9ce-48ad-a4af-1a40a9cf8add</code> would be: concat("{caption}pinboard{/caption}https://.com/#/pinboard/e510f946-f9ce-48ad-a4af-1a40a9cf8add/?col1=fruit&op1=eq&val1=",fruit)</code>

Here, the runtime filter is operating on the column “fruit,” and will only return values that are equal (EQ) to the fruits listed in the columns. To learn more about runtime filters, see About Runtime Filters.

  1. Click Save.