Dashboards & Visualizations

how to disable drilldown for the last row of the table ?

pgadhari
Builder

In my table the last row is the "Average" of all the columns which is calculated based on the query. I want to disable the drilldown click for it. how it can be done ? Attaching image for your reference.

Below is the snippet of query I am using for the table :

| transpose header_field=Category 10 | addtotals | eval Average=round(Total/8,0)| fields - Total | table column "Availability Management" "Identity Access & AD" "Information Security Management" "Monitoring & Analysis" "Server & Storage" "Service Asset & Configuration Mangement" "Service Management" Others Average | transpose header_field=column 25 | rename column as Category

alt text

Labels (2)
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@pgadhari

You can ignore the click using the below code. Can you please try this?

<drilldown>
    <condition match="match('click.value',&quot;Average&quot;)">
        <!--  Intentionally Kept Blank-->
    </condition>
    <!-- Put here other values's condition-->
    <!-- OR put single condition for all values -->
    <condition>
    </condition>
</drilldown>

Thanks

View solution in original post

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@pgadhari

You can ignore the click using the below code. Can you please try this?

<drilldown>
    <condition match="match('click.value',&quot;Average&quot;)">
        <!--  Intentionally Kept Blank-->
    </condition>
    <!-- Put here other values's condition-->
    <!-- OR put single condition for all values -->
    <condition>
    </condition>
</drilldown>

Thanks

0 Karma

pgadhari
Builder

@kamlesh_vaghela - when I try to add that conditional-drilldown, it gives following warning :

invalid child="set" is not allowed in node=conditional-drilldown"

below is my XML code, I am already using for that row (table)

 <drilldown>
          <set token="tok_sas_cat">$click.value$</set>
          <unset token="tok_fm_cat"></unset>
          <unset token="tok_al_cat"></unset>
          <condition match="match('click.value',&quot;Average&quot;)">

          </condition>
          <!-- Put here other values's condition-->
          <!-- OR put single condition for all values -->
          <condition>
          </condition>
 </drilldown>

Also, do I need to put any values where you have written "Put here other value's condition" ??

0 Karma

pgadhari
Builder

some how the set token word did not come. I am already using "set" token in my drilldown option, due to which it is not allowing to put the conditional-drilldown ? please advise ?

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@pgadhari

Can you please try this?

<drilldown>           
  <condition match="match('click.value',&quot;Average&quot;)">

  </condition>
  <condition>
    <set token="tok_sas_cat">$click.value$</set>
    <unset token="tok_fm_cat"></unset>
    <unset token="tok_al_cat"></unset>
  </condition>
</drilldown>

pgadhari
Builder

yes it worked. That was easy. 🙂 Thank you very much.

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...