Drilldown from a line chart to a line chart

[celianou]

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) :

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>

[woodcock · Accepted solution]

Try these, in this order:

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

It will be one of those.

[celianou]

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 !

[niketn]

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

[niketn]

@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?