Dashboards & Visualizations

multiple drilldown possibility on one result table

sbsbb
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

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

jamieadahan
Path Finder

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

jamieadahan
Path Finder

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>

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

kml_uvce
Builder

can you please explain more this ...
Kamal Bisht

0 Karma

sbsbb
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

Venkat_16
Contributor

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

Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!