Dashboards & Visualizations

Drilldown from a line chart to a line chart

celianou
New Member

I need help because I can't do a drilldown and I don't understand why.

Here is my first chart. I wanna click on a point and token the Date (for example 2019-11-22) :
alt text

Then I want to display another graph with a where clause on this Date and here is my xml code :

  <row>
    <panel depends="$breakdown$">
      <title>Test</title>
      <chart>
        <search>
          <query>index="sap-lab" sourcetype=machine | eval temps=strftime(_time,"%Y-%m-%d") | where temps=$breakdown$ | timechart span=30m avg(Temperature) | rename avg(Temperature) as "Average Temperature"</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="charting.chart">line</option>
        <option name="charting.drilldown">all</option>
        <option name="refresh.display">progressbar</option>
      </chart>
    </panel>
  </row>

Here is the code of my token on the first chart :

        <drilldown>
          <set token="breakdown">$Date$</set>
        </drilldown>
Tags (1)
0 Karma
1 Solution

woodcock
Esteemed Legend

Try these, in this order:

$click.value$
$click.value2$
$click.name$
$click.name2$

It will be one of those.

View solution in original post

0 Karma

woodcock
Esteemed Legend

Try these, in this order:

$click.value$
$click.value2$
$click.name$
$click.name2$

It will be one of those.

0 Karma

celianou
New Member

Yes I already tried it. The solution was click.value ! I though I tried it but ... nevermind. Sorry for my questions, I don't know how to close it !

0 Karma

niketn
Legend

@celianou you can accept your own comment as answer to mark this question as answered.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

niketn
Legend

@celianou you would need to add more details. Is the Date field in your first chart string time or epoch? What is the query for first line chart?

Have you tried $row.Date$ instead of $Date$ inside the <drilldown> section of the first line chart?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...