Splunk Search

How to add hyperlink in specific text?

katrinamara
Path Finder

I want to have a hyperlink in my Title text but not all the text in the title will be clickable, the only clickable is the Date. And when I click it will show a small calendar pick so I can choose specific date. Is it possible? The default date is the current date. See below screenshot and code.

alt text

  <input type="link" token="timetok">
            <label>timeNow</label>
            <fieldForLabel>Choose</fieldForLabel>
            <fieldForValue>Choose</fieldForValue>
            <search>
              <query>|makeresults 
    | eval Choose=strftime(now()," %b %d, %Y") 
    | eval choose=strptime(Choose," %b %d, %Y")
    | table Choose choose</query>
              <done>
                <set token="timetok">$result.Choose$</set>
                <set token="timetok1">$result.choose$</set>
              </done>
            </search>
          </input>

     <row>
        <panel>
          <title>Out of Office Summary for $timetok$</title>

          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$"
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between

    | where Leave_Type = "Vacation Leave"
    | dedup EID,Leave_Type,Leave_Start_Date,Status 
    | stats count as Total</query>
              <earliest>0</earliest>
              <latest></latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0xf2b827","0xf2b827"]</option>
            <option name="rangeValues">[0]</option>
            <option name="underLabel">on Vacation</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.vl_tok$=&quot;0&quot;">
                <set token="form.vl_tok">1</set>
                <set token="form.sl_tok">0</set>
                <set token="form.tr_tok">0</set>
                <set token="form.ape_tok">0</set>
                <set token="form.el_tok">0</set>
                <set token="form.eh_tok">0</set>
                <set token="vacation_drilldown">$click.value$</set>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
              <condition match="$form.vl_tok$=&quot;1&quot;">
                <set token="form.vl_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$" 
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between
    | where Leave_Type = "Sick Leave"
    | stats count as Total</query>
              <earliest>0</earliest>
              <latest></latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0xd6563c","0xd6563c"]</option>
            <option name="rangeValues">[1]</option>
            <option name="underLabel">on Sick</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.sl_tok$=&quot;0&quot;">
                <set token="form.sl_tok">1</set>
                <set token="form.vl_tok">0</set>
                <set token="form.tr_tok">0</set>
                <set token="form.ape_tok">0</set>
                <set token="form.el_tok">0</set>
                <set token="form.eh_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <set token="sick_drilldown">$click.value$</set>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
              <condition match="$form.sl_tok$=&quot;1&quot;">
                <set token="form.sl_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$" 
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between

    |dedup EID,Leave_Type,Leave_Start_Date,Status 
    | where Leave_Type = "Training"
    | stats count as Total</query>
              <earliest>$earliest$</earliest>
              <latest>$latest$</latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0x91af27","0x91af27"]</option>
            <option name="rangeValues">[1]</option>
            <option name="underLabel">on Training</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.tr_tok$=&quot;0&quot;">
                <set token="form.tr_tok">1</set>
                <set token="form.sl_tok">0</set>
                <set token="form.vl_tok">0</set>
                <set token="form.ape_tok">0</set>
                <set token="form.el_tok">0</set>
                <set token="form.eh_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <set token="training_drilldown">$click.value$</set>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
              <condition match="$form.tr_tok$=&quot;1&quot;">
                <set token="form.tr_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$" 
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between

    | where Leave_Type = "APE"
    |dedup EID,Leave_Type,Leave_Start_Date,Status 
    | stats count as Total</query>
              <earliest>$earliest$</earliest>
              <latest>$latest$</latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0x3863a0","0x3863a0"]</option>
            <option name="rangeValues">[1]</option>
            <option name="underLabel">on APE</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.ape_tok$=&quot;0&quot;">
                <set token="form.tr_tok">0</set>
                <set token="form.sl_tok">0</set>
                <set token="form.vl_tok">0</set>
                <set token="form.ape_tok">1</set>
                <set token="form.el_tok">0</set>
                <set token="form.eh_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <set token="ape_drilldown">$click.value$</set>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
              <condition match="$form.ape_tok$=&quot;1&quot;">
                <set token="form.ape_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$" 
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between

    |dedup EID,Leave_Type,Leave_Start_Date,Status 
    | where Leave_Type = "Emergency Leave"
    | stats count as Total</query>
              <earliest>$earliest$</earliest>
              <latest>$latest$</latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0xed8440","0xed8440"]</option>
            <option name="rangeValues">[1]</option>
            <option name="underLabel">on Emergency Leave</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.el_tok$=&quot;0&quot;">
                <set token="form.tr_tok">0</set>
                <set token="form.sl_tok">0</set>
                <set token="form.vl_tok">0</set>
                <set token="form.ape_tok">0</set>
                <set token="form.el_tok">1</set>
                <set token="form.eh_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <set token="emergency_drilldown">$click.value$</set>
              </condition>
              <condition match="$form.el_tok$=&quot;1&quot;">
                <set token="form.el_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
          <single>
            <search>
              <query>|inputcsv acn_pmo_ooo_save_search_calendar
    |eval Calendar_Date = "$timetok1$" 
    |eval timetrial=strftime(now(),"%m/%d/%Y"), timetrial=strptime(timetrial,"%m/%d/%Y")
    |eval Choose = if(Calendar_Date=="*.000000",timetrial,Calendar_Date)
    |where Choose=between

    |dedup EID,Leave_Type,Leave_Start_Date,Status 
    | where Leave_Type = "Elective Holiday"
    | stats count as Total</query>
              <earliest>$earliest$</earliest>
              <latest>$latest$</latest>
            </search>
            <option name="colorMode">block</option>
            <option name="drilldown">all</option>
            <option name="height">87</option>
            <option name="link.visible">0</option>
            <option name="rangeColors">["0x5f7396","0x5f7396"]</option>
            <option name="rangeValues">[1]</option>
            <option name="underLabel">on Elective Holiday</option>
            <option name="useColors">1</option>
            <drilldown>
              <condition match="$form.eh_tok$=&quot;0&quot;">
                <set token="form.tr_tok">0</set>
                <set token="form.sl_tok">0</set>
                <set token="form.vl_tok">0</set>
                <set token="form.ape_tok">0</set>
                <set token="form.el_tok">0</set>
                <set token="form.eh_tok">1</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <set token="elective_drilldown">$click.value$</set>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
              <condition match="$form.eh_tok$=&quot;1&quot;">
                <set token="form.eh_tok">0</set>
                <unset token="vacation_drilldown">$click.value$</unset>
                <unset token="training_drilldown">$click.value$</unset>
                <unset token="sick_drilldown">$click.value$</unset>
                <unset token="ape_drilldown">$click.value$</unset>
                <unset token="elective_drilldown">$click.value$</unset>
                <unset token="emergency_drilldown">$click.value$</unset>
              </condition>
            </drilldown>
          </single>
        </panel>
      </row>
0 Karma

mdsnmss
SplunkTrust
SplunkTrust

Try replacing the title with the HTLM tags and using that. Something like this:

<html><h3>Out of Office Summary for <a href="your link">$timetok$</a></h3></html>

You can change the size of the title by adjusting your header attributes. H1 is bigger and gets smaller as you go higher.

0 Karma

mdsnmss
SplunkTrust
SplunkTrust

I actually just saw the calendar pick part of the question. That more seems like an input option rather than hyperlink. That is a bit more complex. I'll see if I can come up with something for that.

0 Karma
Get Updates on the Splunk Community!

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...

Application management with Targeted Application Install for Victoria Experience

Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...