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>
@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...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>
great cheers - thanks 🙂
Anytime! 🙂