Dashboards & Visualizations
Highlighted

multiple drilldown possibility on one result table

Builder

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 ?

0 Karma
Highlighted

Re: multiple drilldown possibility on one result table

Builder

can you please explain more this ...
Kamal Bisht

0 Karma
Highlighted

Re: multiple drilldown possibility on one result table

Builder

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

0 Karma
Highlighted

Re: multiple drilldown possibility on one result table

Contributor

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

Highlighted

Re: multiple drilldown possibility on one result table

Path Finder

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.

Highlighted

Re: multiple drilldown possibility on one result table

Contributor

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

Re: multiple drilldown possibility on one result table

Explorer

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

0 Karma
Highlighted

Re: multiple drilldown possibility on one result table

Explorer

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>
0 Karma