topic Re: how to disable drilldown for the last row of the table ? in Dashboards & Visualizations

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

pgadhari — Sun, 07 Jun 2020 23:42:45 GMT

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

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

kamlesh_vaghela — Mon, 01 Jun 2020 06:59:14 GMT

@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

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

pgadhari — Mon, 01 Jun 2020 09:42:57 GMT

@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" ??

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

pgadhari — Mon, 01 Jun 2020 09:57:19 GMT

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 ?

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

kamlesh_vaghela — Mon, 01 Jun 2020 15:18:44 GMT

@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>

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

pgadhari — Mon, 01 Jun 2020 17:08:56 GMT

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