topic Re: How to create a count down? in Splunk Search

How to create a count down?

Anesthet1ze — Thu, 01 Sep 2022 18:50:26 GMT

Hello,

I need to create a single value panel that displays a countdown from today's date until a target date, how can I achieve this? Right now I am using sample data and I added a field called "GoLiveDate" to the data and put the target date in (which is in the future.) What I want to do is put a panel in that says something like "80 days until Go Live." Then tomorrow it would say "79 days until Go Live" etc etc - Is something like this possible?

Re: How to create a count down?

richgalloway — Thu, 01 Sep 2022 20:04:38 GMT

Subtract the current date from the go-live date and divide by 86400 to get the number of days.

| eval days = (strptime(GoLiveDate, "<<format string>>") - now()) / 86400

where <<format string>> describes the format of the GoLiveDate value.

Re: How to create a count down

Anesthet1ze — Thu, 01 Sep 2022 18:29:31 GMT

Thanks so much for your answer, I'm getting an eval statement malformed, here is the query:

Apologies the field is called GoLive.

| eval days = ((strptime(GoLive, "%Y/%m/%d") - now())/86400

the GoLive field in my data is formatted as such: 20221120

Trying to get it to come up in a single value but it's unhappy with what I did. Apologies, still learning.

Re: How to create a count down

Anesthet1ze — Thu, 01 Sep 2022 18:34:19 GMT

Alright, sorry I got the eval statement to work, it was a bracket issue.. but the result I'm getting is not what I'm looking for it's showing 20,221,120 I'm looking for it to say 80

Re: How to create a count down

Anesthet1ze — Thu, 01 Sep 2022 18:46:02 GMT

Me again! I figured it out, for some reason had to use the table to get it to display properly.. Splunk is still a mystery to me.