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!

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...

SignalFlow: What? Why? How?

What is SignalFlow? Splunk Observability Cloud’s analytics engine, SignalFlow, opens up a world of in-depth ...

Federated Search for Amazon S3 | Key Use Cases to Streamline Compliance Workflows

Modern business operations are supported by data compliance. As regulations evolve, organizations must ...