topic Re: How do you create a dynamic drilldown on a specific row selection? in Dashboards & Visualizations

How do you create a dynamic drilldown on a specific row selection?

mabinn — Tue, 29 Sep 2020 21:16:51 GMT

Hello friends,

I have three columns: product_name, item_sold, and receipt_numbers. Only the product name and item sold are being displayed in my dashboard. When I click a graph, I want to be able to get the receipt numbers of that product:

My query lists the third column with a delimiter to combine all the receipt numbers with a "-".

source=xyz | stats count(item_sold) by product_name, delim="-" values(receipt_numbers) as receipts| mvcombine receipts | table product_name, item_sold

   product_name                      item_sold                   receipts

    shampoo                            3                           123-456-789
    soap                               2                           234-543
    detergent                          1                           192
    toothpaste                         4                           111-234-543-232

so based on my query, I produce a graph with product and item sold. When I click on the "item_sold" from the chart, I want to get the "receipt_number" from that field and pass it to my application. For example, if I click on "4" from toothpaste row, I want to get the string "111-234-543-232"

My XML

<query> my query above  <query>

<drilldown>
  <link target="">
      my_application/ <receipt_number_string>
  </link>
</drilldown>

I've read and tried lots of dynamic drilldown but im still lost. Thanks a lot!

Re: How do you create a dynamic drilldown on a specific row selection?

Justinboucher0 — Tue, 29 Sep 2020 21:17:00 GMT

You need to get the receipt number in a token.

Then your parameter will have my_application/$tkn.receipt_number$

Re: How do you create a dynamic drilldown on a specific row selection?

mabinn — Wed, 19 Sep 2018 01:24:15 GMT

I actually tried doing this but it is not working. I thought this should be the correct answer, but token is not working.

  my_application/ $row. receipts $

However, if I use

    <drilldown>
       <link>
          my_application/ $click.value2 $ 
       </link>
    </drilldown>

I am getting: my_application/

Re: How do you create a dynamic drilldown on a specific row selection?

renjith_nair — Wed, 19 Sep 2018 02:24:12 GMT

@mabinn ,
Which visualization are you using? Table?

Re: How do you create a dynamic drilldown on a specific row selection?

harishalipaka — Wed, 19 Sep 2018 06:21:11 GMT

hi @mabinn

try below example

<dashboard>
  <label>table_3rows</label>
  <row>
    <panel>
      <table>
        <title>Fruits_first_tabel</title>
        <search>
          <query>|makeresults |eval  product_name="shampoo",item_sold=3,receipts="123-456-789" |append [|makeresults |eval  product_name="soap",item_sold=2,receipts="234-543"]  |append [|makeresults |eval  product_name="toothpaste",item_sold=4,receipts="111-234-543-232"] |table product_name item_sold receipts</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">row</option>
        <drilldown>
          <set token="first">$row.receipts$</set>
        </drilldown>
      </table>
    </panel>
  </row>
  <row depends="$first$">
    <panel>
      <table>
        <title>$first$</title>
        <search>
          <query>|makeresults |eval  product_name="shampoo",item_sold=3,receipts="123-456-789" |append [|makeresults |eval  product_name="soap",item_sold=2,receipts="234-543"]  |append [|makeresults |eval  product_name="toothpaste",item_sold=4,receipts="111-234-543-232"] |where receipts="$first$"|table product_name item_sold receipts</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="count">10</option>
        <option name="drilldown">row</option>
        <option name="rowNumbers">false</option>
        <drilldown>
          <set token="second">$click.value$</set>
        </drilldown>
      </table>
    </panel>
  </row>
</dashboard>