topic Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard? in Splunk Search

How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Tue, 18 Oct 2016 22:08:53 GMT

Does anyone know of a way or have a good link on how to set a different drilldown for each cell in a table? I'm using a Simple XML dashboard and I'm able to make a whole column to go to one page, but I wanted to see if I could do the same but by cell. Is that possible?

Thanks

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Tue, 18 Oct 2016 22:27:35 GMT

There's some good documentation on the Splunk website on drilldown from dashboards. You can start here for your specific need.

http://docs.splunk.com/Documentation/Splunk/6.5.0/Viz/tokens#Predefined_tokens_for_dynamic_drilldown

If you share your current dashboard and specific questions, someone in the community will help

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Tue, 18 Oct 2016 22:41:32 GMT

I'd like to be able to configure each cell under availability, performance, Host Health and Host Health 2 to take me to a different page when I click on it.

So if I click on top cell under Availability, I can get taken to a dashboard for Availability for sourcetype mongod and so on.

Thanks

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

nfilippi_splunk — Tue, 18 Oct 2016 23:10:17 GMT

Thanks for taking the time to walk through your use case here. In the example that you describe, are you looking to be taken to a dashboard for Availability, and pass in the argument of sourcetype=mongod to populate a form input?

Or do you have a dedicated dashboard for "Availability of Mongod"?

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Tue, 18 Oct 2016 23:11:37 GMT

Try this runanywhere sample. This should give you some ideas

<dashboard>
  <label>Test Dashboard</label>
  <row>
    <panel>
      <table>
        <title>$x$</title>
        <search>
          <query>index=_internal | stats count by sourcetype</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">row</option>
        <option name="refresh.display">preview</option>
        <drilldown target="NewWindow">
          <condition match="match('click.value', &quot;splunk&quot;)">
            <link>http://www.splunk.com</link>
          </condition>
          <condition match="match('click.value', &quot;mongo&quot;)">
            <link>https://www.mongodb.com/presentations/splunks-hunk-powerful-way-visualize-your-data-stored-mongodb</link>
          </condition>
          <condition field="*">
            <set token="x">did not match</set>
          </condition>
        </drilldown>
      </table>
    </panel>
  </row>
</dashboard>

http://docs.splunk.com/Documentation/Splunk/6.5.0/Viz/tokens#Custom_logic_for_dashboards

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 16:46:58 GMT

dedicated dashboard for each cell.

Thanks

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 17:16:10 GMT

so...I have an individual dashboard for Availability, performance, Host Health and Host Health 2 for each sourcetype and I to go to that dashboard when the value in that particular cell is clicked.

Thanks again

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 17:19:33 GMT

Thanks sundareshr,

I'm trying to figure this out. What condition directs you to the mongodb site in the sample above? I just keep going to the splunk site when I click on the table

Thanks again

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Wed, 19 Oct 2016 17:49:46 GMT

Sourcetype mongod should take you to mongodb site

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 17:59:44 GMT

got it..ok, that makes sense for specific values but I'm trying to figure out how to assign a specific link to each cell.

Any ideas on that?

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Wed, 19 Oct 2016 19:30:58 GMT

If you share your URLs there may be better dynamically build your URL, but for now, you can try this

        <drilldown>
          <set token="m">$click.value$#$click.name2$</set>
          <eval token="click">case($m$="mongod#count", "splunk.com", $m$="splunkd#count", "google.com", 1=1, "UNK")</eval>
          <link target="_blank">http://$click$</link>
        </drilldown>

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Tue, 29 Sep 2020 11:28:08 GMT

I just need them to go to a prebuilt dashboard when they click so a sample would be:

if you click on the count value in the mongod row you go to: /app/Test/table_cell_highlighting_test

If you click on mongod cell you go to:
/app/Test/alerts

If you click on scheduler cell you go to:
/app/Test/reports

if you click on the count value in the scheduler row you go to:

/app/Test/search

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 21:06:04 GMT

Thanks again for all the assistance

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 21:16:25 GMT

Thanks sundareshr,

I'm trying to redirect to different app/dashboards

like clicking on mongod takes you to: /app/Test/reports

Clicking on count in mongod row takes you to :/app/Test/searches

Scheduler takes you to: /app/Test/

Count in Scheduler row takes you to : /app/Test/reports

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Wed, 19 Oct 2016 23:06:41 GMT

I think I may have it solved by combining the 2 solutions that you gave me. I'm going to try it out tonight/tomorrow to see if it fits what I'm trying to do.

Feel free to send any other suggestions though but I'll let you know if the combo solution works out in the end 🙂

Thanks again!!!

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Wed, 19 Oct 2016 23:41:19 GMT

Since all of them redirect to /app/test you should keep that static in the link tag. Having said that, a different approach would be to keep one dashboard and change the data in the dashboard by passing in values user clicks on your table. That way, you only have to maintain one dashboard. Its easy for me to say 🙂

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sidekix24 — Thu, 20 Oct 2016 03:54:53 GMT

That's a great idea....but you know I have to ask, do you know how to pass a token from one dashboard to another?

🙂

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

sundareshr — Thu, 20 Oct 2016 03:59:17 GMT

In the querystring. take a look at this documentation

http://docs.splunk.com/Documentation/Splunk/6.5.0/Viz/PanelreferenceforSimplifiedXML#Drilldown_elements

<table>
<search>index=_internal</search>

<!-- Pass the clicked row's 'count'-column value    -->
<!-- to populate a destination form's 'foo' token. -->
<drilldown>
  <link>
  /app/search/simple_xml_form?form.foo=$row.count$
  </link>
</drilldown>
</table>

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

vino06 — Thu, 14 Sep 2017 12:20:47 GMT

Hi,

How can I make a drill down that has the same Field name but different Value.

Example, I have a field it's name is System and two values which are McLaren and IRIS SOLO. If I click the McLaren it will open the McLaren dashboard then for the IRIS SOLO it will open the IRIS SOLO dashboard. But in my XML I'm having trouble doing it. Here is my code, hope you can help me to figure this out.

      <condition field="System">
        <link target="McLaren">https://soic-itsi:8000/en-US/app/splunk_app_windows_infrastructure/mclaren_availability?form=$row.McLaren$</link>
      </condition>

      <condition field="System">
        <link target="IRIS SOLO">https://soic-itsi:8000/en-US/app/splunk_app_windows_infrastructure/iris_solo_monitoring?form=$row.IRIS SOLO$</link>
      </condition>
    </drilldown>

Re: How to set a different drilldown for each cell in a table in my Simple XML dashboard?

reschal — Mon, 27 Nov 2017 15:02:56 GMT

I have an additional question:

Everything works fine but i have one problem:

In my case there is for example one field called splunk and one field called splunk_two.

By typing this condition:
condition match="match('click.value', "splunk")"

there is no way to get to the link of splunk_two because there is the expression "splunk" in it.

Is there any option to strictly define the click.values?

Thanks for your help!