link from lookup table into drilldown new page

[spisiakmi]

Hi, any help, pls?

Here is the description:

1. lookupTable(links.csv):columnName(Link)
2. lookupTable(links.csv):columnValue(https://www.google.com)
3. in the dashboard Table Visu: | inputlookup links.csv
   | head 1
   | table Link
4. how to click on the tableCell (https://www.google.com) and new browser window with the https://www.google.com will be opened?

[ITWhisperer]

Create a drilldown on the table that opens a link using the value from the clicked cell.

[spisiakmi]

Yes, you right:
<drilldown>
<link target="_blank">$doc_tkn|n$</link>
</drilldown>

And. How I can place there universal name of the link? Like: "Click here" and this will have different hyperlink in background?

[ITWhisperer · Accepted solution]

You don't have to show the column with the url in but you can still use it in the drilldown

    <panel>
      <table>
        <search>
          <query>| inputlookup links.csv
| eval Label="Click here"</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">cell</option>
        <option name="refresh.display">progressbar</option>
        <drilldown>
          <link target="_blank">$row.Link|n$</link>
        </drilldown>
        <fields>Label</fields>
      </table>
    </panel>

[spisiakmi]

Hi ITWhisperer, you are unbelievable. It is working. Even I nowhere show the Link, it is hidden behind the Label. Thank you very much.