Dashboards & Visualizations

Drilldown Sparkline

fb12345
Engager
Hey,
I have an Dashboard similiar to the attached one, also with an Sparkline. Now I want a drilldown to another Dashboard and I want to pass the Location to the other Dashboard.
Example: 
1. Click on single Value of New York
2. Drilldown to the other Dashboard 
3. Dropdown in the other Dashboard, where New York is selected
 
Does anybody know how this is possible?
Thanks in advance
 
<dashboard>
  <label>testme</label>
  <row>
    <panel>
      <single>
        <search>
          <query>
<![CDATA[            
| makeresults
| eval Location="New York", value=1
| append
    [| makeresults
    | eval Location="Berlin", value=2 ]
| timechart avg(value) by Location
| search Berlin=*        
           
]]>  
          </query>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="height">150</option>
        <option name="numberPrecision">0.0</option>
        <option name="rangeColors">["0x555","0x53a051","0xf8be34","0xdc4e41"]</option>
        <option name="rangeValues">[$service_003.threshold_normal$,$service_003.threshold_medium$,$service_003.threshold_critical$]</option>
        <option name="refresh.display">progressbar</option>
        <option name="showSparkline">$measurements.showSparkline$</option>
        <option name="showTrendIndicator">$measurements.showTrendIndicator$</option>
        <option name="trellis.enabled">1</option>
        <option name="trellis.scales.shared">1</option>
        <option name="trellis.size">small</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">auto</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <drilldown>
          <link target="_blank">/app/hsy_ops_da_servicetrace/hsy_kpi_dynamic_2?form.service=$service_003.name$</link>
        </drilldown>
      </single>
    </panel>
  </row>
</dashboard>
Labels (1)
0 Karma
1 Solution

Vardhan
Contributor

Hi,

Try the below settings its not a accurate one .Feel free to modify if it is necessary.

<drilldown>
<condition match="'click.name2' == &quot;(Mention your row name)&quot; AND 'click.value2' == &quot;(Mention your row value)&quot;">
<set token="test">$row.Newyork$</set>
<link target="_blank">other dashboard link</link>
</condition>
</drilldown>

View solution in original post

0 Karma

fb12345
Engager

Hey,

thank you for your answer and it also works partially, but the token click.name2 has always the value "result" ,  no matter whether  I click on the Single value of "berlin" or on the single value of "New York". Therefore, the condition would always be true, when the single values of Berlin and New York are the same and this could happen in my dashboard.

Do you have any other idea, how to solve it?

 

0 Karma

Vardhan
Contributor

Hi,

Try the below one it will work.  Mention the filed name in the place of result.And field value in the condition. And we are passing the field value  "Newyork"  explicitly to the token.

<drilldown>
<condition match="'click.name2' == &quot;result&quot; AND 'click.value2' == &quot;Newyork&quot;">
<set token="testing">$row.Newyork$</set>
<link target="_blank">(Dashboardlink)?result="$testing$"</link>
</condition>

0 Karma

Vardhan
Contributor

Hi,

Try the below settings its not a accurate one .Feel free to modify if it is necessary.

<drilldown>
<condition match="'click.name2' == &quot;(Mention your row name)&quot; AND 'click.value2' == &quot;(Mention your row value)&quot;">
<set token="test">$row.Newyork$</set>
<link target="_blank">other dashboard link</link>
</condition>
</drilldown>

0 Karma
Get Updates on the Splunk Community!

.conf25 Registration is OPEN!

Ready. Set. Splunk! Your favorite Splunk user event is back and better than ever. Get ready for more technical ...

Detecting Cross-Channel Fraud with Splunk

This article is the final installment in our three-part series exploring fraud detection techniques using ...

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...