Dashboards & Visualizations

How to edit my Simple XML to create a drilldown for clicking on any row of a table to open a new dashboard?

smhsplunk
Communicator

I am creating a drilldown where I click on any row of a table and it activates a new dashboard, but I cannot get this code to run.

 <panel>
      <table>
        <search>
          <query>| inputlookup locations.csv | search *  state="$get_locations$" |  table address, state, country | sort by country</query>
        </search>
        <option name="count">30</option>

        <drilldown target="_blank">
          <set token="get_location">$click.value$</set>
          <link>
            \apps\myapp\local\data\ui\views\new_page
            </link>
        </drilldown>

        <option name="wrap">true</option>
        <option name="rowNumbers">false</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">row</option>
      </table>

    </panel>

The new dashboard is

\apps\myapp\local\data\ui\views\new_page.xml

Do I have to pass a value to get this activated? Shouldn't it work as it says

http://docs.splunk.com/Documentation/Splunk/6.3.3/Viz/Dynamicdrilldownindashboardsandforms
1. Use a relative path to connect to a dashboard.
1) path/viewname

0 Karma

smhsplunk
Communicator

Thanks both of you.
I think I didnt quite get this line before

name_form?form.state=$row.state$

Then I found this post, which was very thorough

https://answers.splunk.com/answers/169192/how-to-pass-multiple-values-from-a-drilldown-in-a-1.html

0 Karma

gyslainlatsa
Motivator

hi,

if your second dashboard is one form, try like this:

      <panel>
       <table>
         <search>
           <query>| inputlookup locations.csv | search *  state="$get_locations$" |  table address, state, country | sort by country</query>
         </search>
         <option name="count">30</option>

         <drilldown>
           <link>/app/myapp/name_form?form.state=$row.state$</link>
         </drilldown>

         <option name="wrap">true</option>
         <option name="rowNumbers">false</option>
         <option name="dataOverlayMode">none</option>
         <option name="drilldown">row</option>
       </table> 
     </panel>

renjith_nair
Legend

Below works for me

         <drilldown>
           <set token="get_location">$click.value$</set>
           <link>
             /apps/myapp/new_page
             </link>
         </drilldown>
---
What goes around comes around. If it helps, hit it with Karma 🙂
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...