topic Re: multiple drilldown possibility on one result table in Dashboards & Visualizations

multiple drilldown possibility on one result table

sbsbb — Sat, 16 Mar 2013 06:26:41 GMT

Is it possible to have on the same row, to have multiple possibility of drilldown, based on the same cells ?

Is there a way to have a context menu ? Or how could I achieve that ?

Re: multiple drilldown possibility on one result table

kml_uvce — Sun, 17 Mar 2013 03:56:46 GMT

can you please explain more this ...
Kamal Bisht

Re: multiple drilldown possibility on one result table

sbsbb — Tue, 19 Mar 2013 07:20:33 GMT

Lets Say I have one SimpleResult Row, I want beeing able to make a drilldown with a query based on fields Row.F1 Row.F2,
and another drilldown with another query based on Row.F1 and Row.F3...

Re: multiple drilldown possibility on one result table

Venkat_16 — Mon, 05 Jan 2015 10:47:43 GMT

Where you able to acheieve this , we are facing the same issue. Please let us know how?

Re: multiple drilldown possibility on one result table

pepper_seattle — Thu, 21 Apr 2016 16:28:22 GMT

I believe this will answer your question (on the off chance no one has already). To get multiple drilldowns by field on a single report/dashboard panel do the following in your dashboard xml:

<drilldown target="_blank">
          <link field="<field name>"><link>=$row.<field name>$/</link>
          <link field="<field name>"><link></link>
</drilldown>

example:
   <drilldown
              <link field="username">https://www.facebook.com/=$row.username$/</link>
              <link field="country">https://www.google.com/maps/place/$row.country$/</link>
    </drilldown>

You put your distinct field names in where I've noted above. The field and token take into account which field cell is being clicked and populate your link with the result.

Re: multiple drilldown possibility on one result table

worshamn — Thu, 13 Sep 2018 14:13:09 GMT

I wanted to write an update here as this method is now deprecated and in case someone finds this page like I did they will have the new answer. Like it pepper_seattle's previous answer, the slight change for the new formatting would look like so:

<option name="drilldown">cell</option>
<drilldown>
   <condition field="username">
     <link target="_blank">https://www.facebook.com/=$row.username$/</link>
   </condition>
   <condition field="country">
     <link target="_blank">https://www.google.com/maps/place/$row.country$/</link>   
  </condition>
</drilldown>

But what is also cool is that you could click on say username and use a value from something else in the row instead but still requires that you are clicking on the username field. Like this:

<option name="drilldown">cell</option>    
<drilldown>
    <condition field="username">
      <link target="_blank">https://www.google.com/maps/place/$row.country$/</link>
    </condition>
</drilldown>

Re: multiple drilldown possibility on one result table

jamieadahan — Tue, 11 Feb 2020 14:42:25 GMT

Hi this works fine for me however when I now click on a field that is not one of the two in the condition it exits off the dashboard and into a search query

Re: multiple drilldown possibility on one result table

jamieadahan — Tue, 11 Feb 2020 14:52:54 GMT

Sorry I just looked this up and I found an answer adding in the <condition> tags blank treats the rest of the options as nothing

    <condition field="username">
      <link target="_blank">https://www.facebook.com/=$row.username$/</link>
    </condition>
    <condition field="country">
      <link target="_blank">https://www.google.com/maps/place/$row.country$/</link>   
   </condition>
<condition></condition>
 </drilldown>