topic Re: drilldown for field values in a dashboard in Dashboards & Visualizations

drilldown for field values in a dashboard

Gowthamdevaraj — Tue, 31 Mar 2020 05:13:08 GMT

Hello Everyone,

I want to create a dashboard drill down based on filed values.

example: I have a dashboard with a field name "Product" which contains various list of product such as product A, product B etc..
Now I want to create a drill down dashboard, based on filed values, If i click in Product A it has to take to a dashboard for product A and similarly to product B and respective Dashboards.

Thanks

Re: drilldown for field values in a dashboard

vnravikumar — Tue, 31 Mar 2020 13:04:50 GMT

Check the below sample, here I checked condition for sourcetype =splunkd and redirect to splunkd dashboard similarly you can check for others

<dashboard>
  <label>Drilldown</label>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal |stats count by sourcetype</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">cell</option>
        <drilldown>
          <condition match="isnotnull('row.sourcetype') AND 'row.sourcetype' == &quot;splunkd&quot;">
            <link target="_blank">/app/search/splunkd</link>
          </condition>
          <condition >
          </condition>
        </drilldown>
      </table>
    </panel>
  </row>
</dashboard>

Create dashboard names with drilldown value. for example here splunkd

<dashboard>
  <label>Drilldown</label>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal |stats count by sourcetype</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">cell</option>
        <drilldown>
          <condition match="isnotnull('row.sourcetype')">
            <link target="_blank">/app/search/$row.sourcetype$</link>
          </condition>
          <condition >
          </condition>
        </drilldown>
      </table>
    </panel>
  </row>
</dashboard>

Re: drilldown for field values in a dashboard

woodcock — Tue, 31 Mar 2020 13:33:16 GMT

This is the default behavior so just use the GUI to turn it on. Click Edit and then the hamburger menu which is the 4th/last panel edit icon.