topic Re: In a dashboard with a custom drilldown, how would I add 1ms to earliest=$click.value$ to get latest? in Dashboards & Visualizations

In a dashboard with a custom drilldown, how would I add 1ms to earliest=$click.value$ to get latest?

damucka — Wed, 14 Nov 2018 11:05:50 GMT

Hello,

In my dashboard, I need to define the custom drilldown where I would like to transport the _time, which is in the first column of my panel table. For that I need to have earliest and latest defined, where latest would be = earliest+1ms (at least that is how the Auto drilldown option gets it).

How would I do it?

My custom drilldown search looks as follows at the moment:

    index=mlbso sourcetype=*_transports source="*$sourcesid$*.$targetsid$" transport_exitcode=8 earliest=$click.value$ latest=???

Please adise.

Kind Regards,
Kamil

Re: In a dashboard with a custom drilldown, how would I add 1ms to earliest=$click.value$ to get latest?

kmaron — Wed, 14 Nov 2018 16:15:07 GMT

You should be able to do an eval to add the time.

 <drilldown>
           <eval token="latesttime">$click.value$+1ms</eval>
           <link>index=mlbso sourcetype=*_transports source="*$sourcesid$*.$targetsid$" transport_exitcode=8 earliest=$click.value$ latest=$latesttime$</link>
 </drilldown>

Re: In a dashboard with a custom drilldown, how would I add 1ms to earliest=$click.value$ to get latest?

damucka — Thu, 15 Nov 2018 08:55:55 GMT

Thank you.
It worked with

<eval token="latesttime">$click.value$+1ms</eval>

Re: In a dashboard with a custom drilldown, how would I add 1ms to earliest=$click.value$ to get latest?

damucka — Thu, 15 Nov 2018 08:56:09 GMT

$click.value$+0.001