How to create a count down?

[Anesthet1ze]

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?

[richgalloway · Accepted solution]

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.

[Anesthet1ze]

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.

[Anesthet1ze]

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 

[Anesthet1ze]

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.