Timeline - Custom Visualization: Is it possible to extract the duration from a graph in a drilldown?

[robertlynch2020]

Is it possible to extract the duration from a graph in a drilldown, even though the duration has not been displayed in the chart (it is in the table behind the chart)? If not, how do i access referencing the "start" or "stop" seen in the image below?

    <viz type="timeline_app.timeline">
        <search>
          <query>eventtype=mlc sourcetype=lts_timings host=$host_token$ | eval duration_seconds=duration_seconds*1000 | table _time task_name task_name2 duration_seconds start end | sort $Name_or_Duration2$ | rename task_name as Event_Name | rename task_name2 as Event_Name2 | search Event_Name=*$Task_Search$*</query>
          <earliest>$tps_selection.earliest$</earliest>
          <latest>$tps_selection.latest$</latest>
        </search>
        <option name="height">399</option>
        <option name="timeline_app.timeline.axisTimeFormat">SECONDS</option>
        <option name="timeline_app.timeline.colorMode">categorical</option>
        <option name="timeline_app.timeline.maxColor">#DA5C5C</option>
        <option name="timeline_app.timeline.minColor">#FFE8E8</option>
        <option name="timeline_app.timeline.numOfBins">6</option>
        <option name="timeline_app.timeline.tooltipTimeFormat">SECONDS</option>
        <option name="timeline_app.timeline.useColors">1</option>
        <drilldown>
          <set token="TEST_GANTT_VALUE">$row.Event_Name$</set>
           <set token="TEST_GANTT_VALUE2">$row.Event_Name2$</set>

           <set token="TEST_GANTT_duration">$row.duration_seconds$</set>
        <eval token="TEST_GANTT_start">$row._time$ - 3600</eval>
        <eval token="TEST_GANTT_end">$row._time$ - 3500</eval>


        </drilldown>
      </viz>

[niketn · Accepted solution]

@robertlynch2020...Although row.<YourFieldName> might not be available with Timeline, you can use $earliest$ and $latest$ visualization tokens to compute duration using eval. Please try out the following code:

    <drilldown>
      <set token="Earliest">$earliest$</set>
      <set token="Latest">$latest$</set>
      <eval token="duration">if(len($latest$)=0,0,$latest$-$earliest$)</eval>
      <eval token="start">$earliest$ - 3600</eval>
      <eval token="end">if(len($latest$)=0,0,$latest$-3500)</eval>
    </drilldown>

[robertlynch2020]

great cheers - thanks 🙂

[niketn]

Anytime! 🙂