Dashboards & Visualizations
Highlighted

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

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
Highlighted

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

SplunkTrust
SplunkTrust

Below works for me

         <drilldown>
           <set token="get_location">$click.value$</set>
           <link>
             /apps/myapp/new_page
             </link>
         </drilldown>
Highlighted

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

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>
Highlighted

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

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