I have a field that stores a dynamic URL. It is always unique. I am clicking that link and it takes me to a report in a different platform. How can I show customized hyperlink text on the dashboard instead of showing the full link/URL?
Example: "Report Link" instead of https://etc...
I don't think I can use eval because the field is dynamic.
Are you trying to do this in Table or Chart visualization? I am hoping this is for Table since you want to Show Report Link.
You can use
<fields> Simple XML Configuration reference and show only the required fields. You Dynamic URL Field will be hidden and still available as token for drilldown.
Following is a sample code since you have not provided field names for your dashboard:
Step 1: Add a dummy "Report Link" field to your search. Pipe the following:
| eval reportLink="Report Link"
Step 2: Edit the Simple XML for table and after
<fields>, to add the fields you need including the dummy link field reportLink
<fields>your_field_1, your_field_2, your_field_3, reportLink</fields>
Step 3: Code drilldown for table to allow click only if reportLink field value is clicked(optional). Code link to launch the URL based on your_URL_Field. PS: Based on the URL partial, internal to Splunk, external, you might need to adjust the code for link (however, since you just want to hide the URL, I expect you already have this in place.
<drilldown> <condition field="reportLink"> <link>$row.your_URL_Field$</link> </condition> <drilldown>
Refer to Splunk Documentation for details on the following:
fields Attribute: https://docs.splunk.com/Documentation/Splunk/latest/Viz/PanelreferenceforSimplifiedXML#Attributes_8
Link : http://docs.splunk.com/Documentation/Splunk/latest/Viz/EventHandlerReference#link
Also check out Table Elements With Hidden Fields Example and DrillDown Elements section in the Splunk 6.x Dashboard Examples App for examples.
PS: Something similar can be done for Charts as well, but the steps are a bit different.
This answer solved the problem for me. I was generating the whole URL, so I had to change the link statement like so:
Thanks for the comprehensive answer!
Found this answer because I am trying to solve the same problem as OP. Also found that the | fieldformat code breaks the link to the external search.
Here is the XML code we are using to make the link clickable, could that be the problem?
<drilldown target="blank"> <condition field="HyperLink"> <link>$click.value2|n$</link> </condition> </drilldown>
Edit to add: