Dashboards & Visualizations
Highlighted

How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Explorer

I am displaying a table with running processes and few metrics. If the user clicks on any column then the column's name should get passes to another dashboard which displays graph. below is the code which displays the table,






False
1


splunk.search.job
True
1


dashboard










Type System Name

stringreplace



host=
True




span
datetime

  <module name="SubmitButton">
    <param name="allowSoftSubmit">True</param>
    <param name="label">Search</param>
    <!-- End Header -->
    <!-- Begin Modules -->

     <module name="HiddenSearch" layoutPanel="panel_row1_col1" group="Running Processes (Point-in-Time)" autoRun="False">
      <param name="search"> $computername$ index=winserver_process earliest=`ChangeTime("$datetime$","-3m")` latest=`ChangeTime("$datetime$","+3m")` NOT instance=Idle NOT instance=_Total | dedup source,instance | eval instance=Upper(instance) | stats first(*) AS * by instance | join host type=outer [search index=winserver_config $computername$ sourcetype=WMI:SysInfo earliest=-14d@d latest=now | dedup host | fields host,NumberOfLogicalProcessors] | eval "% Processor Time"=round(if(isint(NumberOfLogicalProcessors),'%_Processor_Time'/NumberOfLogicalProcessors,'%_Processor_Time'),1) | eval "Private Bytes (MB)"=round('Private_Bytes'/1024/1024,2) | eval "Working Set (MB)"=round('Working_Set'/1024/1024,2) | eval "Write Ops/sec"=round('IO_Write_Operations/sec',2) | eval "Read Ops/sec"=round('IO_Read_Operations/sec',2) | eval "Page Faults/sec"=round('Page_Faults/sec',2) | eval Handles=round(Handle_Count,2) | eval Threads=round(Thread_Count,2) | eval "Elapsed Time"=round(Elapsed_Time,0) | eval "ID Process"=round(ID_Process,0) | rename instance AS Process | fields Process "% Processor Time" "Private Bytes (MB)" "Working Set (MB)" "Page Faults/sec" "Write Ops/sec" "Read Ops/sec" "Handles" "Threads" "ID Process" "Elapsed Time" | fillnull </param>
      <module name="JobProgressIndicator" />
      <module name="EnablePreview">
        <param name="display">False</param>
        <module name="Count">
          <param name="options">
            <list>
              <param name="text">10</param>
              <param name="selected">True</param>
              <param name="value">10</param>
            </list>
            <list>
              <param name="text">20</param>
              <param name="value">20</param>
            </list>
            <list>
              <param name="text">50</param>
              <param name="value">50</param>
            </list>
          </param>
          <module name="MSPager">
            <param name="entityName">results</param>
            <module name="FilterableResultsTable">
              <param name="displayRowNumbers">off</param>
                </param>
              </module>
            </module>
          </module>
        </module>
      </module>
    </module>      
  </module>
</module>


Thanks in advance.

0 Karma
Highlighted

Re: How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Contributor

By "another dashboard" do you mean a different panel within the same dashboard?

0 Karma
Highlighted

Re: How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Explorer

No its another dahsboard which should display the graph for top five processes for the metric that user selects in the table.

0 Karma
Highlighted

Re: How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Explorer

I have added the Simple Drilldown module and now the view is navigating to anither dashboard but the instance value is not getting passed.

         <param name="links">
           <param name="*">
           /app/ms_reap_sh_server/Cpu-new?instance=11
   </param>
         </param>    
       </module>

Can anyone help me on this?

0 Karma
Highlighted

Re: How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Builder

Have you considered using Sideview Utils? Since you are using Advanced.XML (and good for you for doing so) if you are not using Sideview Utils you are missing out on the best tool for the job. With Sideview you can pass one or more arguments from your results table to a new dashboard and it is easy to do. The documentation will help you get exactly what you want in minutes.

for example, this code, will pass the field from the MODEL column from the row you clicked to a new dashboard named ModelSales

<module name="Redirector">
  <param name="arg.MDS">$row.fields.MODEL$</param>
  <param name="target">_blank</param>
  <param name="url">ModelSales</param>
</module>
0 Karma
Highlighted

Re: How to create drilldown from a table column to display a chart in another dashboard using advanced xml?

Explorer

I think that is not possible yet with splunk

0 Karma