Dashboards & Visualizations

Setting time frame values dynamically for splunk dashboard

Ashwin3
Engager

I have a use case where once a particular datetime is entered as input on the dashboard. Need to show search log results panel from two time frames side by side.  

say if the entered value is "07/06/2022:14:00:00"

1) -1hr from the time period entered (here in this case "07/06/2022:13:00:00 -"07/06/2022:14:00:00"

2) From the time period entered to till now (here in this case "07/06/2022:14:00:00 -NOW"

I am capturing the datetime entered as a timetoken

how to set another time token relative to the value entered on screen in dashboard? so that i can use both these tokens as earliest and latest for the first usecase.

Thanks

Labels (3)
0 Karma

diogofgm
SplunkTrust
SplunkTrust

You can use relative_time to eval tokens in your dashboard

e.g -1h

<eval token="new_token">relative_time($timeToken$,"-1h")</eval>

As for the now you can just use your time field as a earliest token in the search itself.

On both cases you'll probably need to use strftime to process your timestamp token format

From docs:

https://docs.splunk.com/Documentation/SplunkCloud/latest/Viz/tokens

------------
Hope I was able to help you. If so, some karma would be appreciated.
0 Karma

Ashwin3
Engager

Thank you. Will try once with this and confirm @diogofgm 

  <eval token="formatted_token">strptime($timeToken$,"%m/%d/%Y:%T")</eval>

 <eval token="new_token">relative_time($formatted_token$,"-1h")</eval>

I am trying with the above one but looks like <eval> is not getting accepted as child node for any of the form elements like <input>, <fieldset> etc. where can we place this <eval> step in UI form?

 

Also is there a way where we can accept datetime as input directly from dashboard. Currently i see a Time input but it does not allow to select a particular time. Hence am using text field for getting the datetime value.

 

Thanks.

0 Karma

diogofgm
SplunkTrust
SplunkTrust

Inside input > change tags. so it would be input > change > eval 

Check this part of the docs I shared before:
https://docs.splunk.com/Documentation/SplunkCloud/latest/Viz/tokens#Define_tokens_for_conditional_op...

You could use a time picker since it already creates tokens for you. if you name your time picker timepicker you'll have $timepicker.earliest$ and $timepicker.latest$ and use these to then eval the new tokens 

------------
Hope I was able to help you. If so, some karma would be appreciated.
Get Updates on the Splunk Community!

Pro Tips for First-Time .conf Attendees: Advice from SplunkTrust

Heading to your first .Conf? You’re in for an unforgettable ride — learning, networking, swag collecting, ...

Raise Your Skills at the .conf25 Builder Bar: Your Splunk Developer Destination

Calling all Splunk developers, custom SPL builders, dashboarders, and Splunkbase app creators – the Builder ...

Hunt Smarter, Not Harder: Discover New SPL “Recipes” in Our Threat Hunting Webinar

Are you ready to take your threat hunting skills to the next level? As Splunk community members, you know the ...