topic Can you help me pass earliest and latest time tokens to another panel in a dashboard? in Dashboards & Visualizations

Can you help me pass earliest and latest time tokens to another panel in a dashboard?

Deepz2612 — Mon, 01 Apr 2019 13:23:11 GMT

Hi,

I have the Begin time and End time as below for an event (which is again extracted using another query)

Begin time : 4:43:55:336 AM
End time : 4:53:00:00 AM

I wanted to pass this earliest and latest time for another panel in the dashboard.

Could you kindly help

Re: Can you help me pass earliest and latest time tokens to another panel in a dashboard?

kamlesh_vaghela — Mon, 01 Apr 2019 13:28:24 GMT

@Deepz2612
You have the Begin time and End time!! But what date you want to consider ?? Current date?

Re: Can you help me pass earliest and latest time tokens to another panel in a dashboard?

kamlesh_vaghela — Mon, 01 Apr 2019 13:38:27 GMT

@Deepz2612
You have the Begin time and End time!! But what date you want to consider ?? Current date?

In case of the current date, you can update your another search with below search logic to get Begin_time and End_time.

| makeresults 
| eval date=strftime(now(),"%Y-%m-%d") 
| eval Begin_time=strptime(date." 4:43:55:336 AM","%Y-%m-%d %H:%M:%S:%3Q")
| eval End_time=strptime(date." 4:53:00:00 AM","%Y-%m-%d %H:%M:%S:%3Q")

Here I have used your provided static value as Begin_time and End_time. You can use your filed name also.
In the date field you can mention your required date as well.

[UPDATED]

Consider below search.

| makeresults 
| eval Begin_time=strptime("04/01/2019 4:43:55:336 AM","%d/%m/%Y %H:%M:%S:%3Q")
| eval End_time=strptime("04/01/2019 4:53:00:00 AM","%d/%m/%Y %H:%M:%S:%3Q")

Thanks

Re: Can you help me pass earliest and latest time tokens to another panel in a dashboard?

Deepz2612 — Mon, 01 Apr 2019 13:40:28 GMT

I'm sorry..
Begin time and End time will have the date as well. I missed to add it.
Begin time : 04/01/2019 4:43:55:336 AM
End time : 04/01/2019 4:53:00:00 AM

Re: Can you help me pass earliest and latest time tokens to another panel in a dashboard?

kamlesh_vaghela — Mon, 01 Apr 2019 13:48:59 GMT

@Deepz2612

I have updated my answer. Please check it.