topic Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats? in All Apps and Add-ons

How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

abhi04 — Mon, 19 Mar 2018 07:43:06 GMT

How to create a drill down from one panel to another? I don't have any data for example but any scenario for explanation would be really appreciated.

Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

p_gurav — Mon, 19 Mar 2018 07:51:47 GMT

This may help you:
https://answers.splunk.com/answers/230345/how-can-i-drill-down-from-one-panel-pie-chart-to-a.html

Also refer this doc:
http://docs.splunk.com/Documentation/Splunk/7.0.2/Viz/ContextualDrilldown

Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

tiagofbmm — Mon, 19 Mar 2018 07:52:42 GMT

Hello

Please take this example code I created (it is generic so just copy and paste to your instance).

You have a pi-chart in the top and when you click a row, it assigns a token "src" that is used below for showing a table of count agains time to that corresponding drilled down value:

  <dashboard>
  <label>DrillDownPanelToAnother</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>| tstats count where index=_internal by source</query>
          <earliest>-60m@m</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">pie</option>
        <drilldown>
          <set token="src">$click.value$</set>
        </drilldown>
      </chart>
    </panel>
  </row>
  <row>
    <panel>
      <table>
        <search>
          <query>| tstats count where index=_internal AND source="$src$"  by _time span=1h</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
  </row>
</dashboard>

Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

niketn — Mon, 19 Mar 2018 08:10:15 GMT

@tiagofbmm, I think you got the requirement reversed. Drilldown from Pie Chart to Table.

@abhi04, Refer to one of my recent answers for the same (you can refer to unaccepted answer which is closed to your request): https://answers.splunk.com/answers/625052/display-different-panel-depends-on-selected-name-i.html

Also refer to Splunk Dashboard Examples App which has several examples on Drilldown.

Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

tiagofbmm — Mon, 19 Mar 2018 08:16:37 GMT

@niketnilay thanks for noticing that. Edited and corrected

Re: How to create a drill down in dashboard where if clicked on one panel i.e. a pie chart takes us to a second panel with table formats?

abhi04 — Tue, 20 Mar 2018 02:48:20 GMT

Thanks niketnilay and tiagofbmm.