Drill down example based on user clicking on chart.?

[SanthoshSreshta]

Hi.

How to make drill downs from one tab to another tab or to the same tab ( Using Oracle DB) in splunk DB Connect 1.17 App
I am able to get simple chart but not able to get details based on my input on chart.
Here are my variables: Amount_LCY, Account_Number.
how to get detail of the Account_Number which the user clicks.???
Please find the image for the simple chart.

Here is my code:

<dashboard>
  <label>ddddddd</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>| dbquery EDWHCMB limit=100 "SELECT DISTINCT  DWT_STMT_ENTRY.ACCOUNT_NUMBER,DWT_STMT_ENTRY.AMOUNT_LCY from DWT_STMT_ENTRY"</query>
          <earliest>0.000</earliest>
          <latest></latest>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">column</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
      </chart>
    </panel>
  </row>
</dashboard>

please give me the information regarding drildowns.
Thanks,
Santhosh.

[SanthoshSreshta · Accepted solution]

Got my requirement 🙂
I used this link for reference 🙂
Drill Down from Table

[gibba]

i try to to write a example

<-drilldown target="_blank"->
<-link field="field1">/app/appname/newtab?form.token=$token$<-/link>
<-/drilldown->
<-/chart->

if you need to take a value you can try for the token $click.value$ or $row.field$

try this app, there are a lots of example

https://splunkbase.splunk.com/app/1603/