Splunk Search

Convert negative seconds to duration

joxley
Path Finder

I have a column of seconds, some of which are negative (representing an outage). I want to use tostring(duration, "duration") on the column, but that doesn't work

| stats count | eval count=-5 | eval duration=tostring(count, "duration")
1 Solution

joxley
Path Finder

Absolute the duration in the conversion and prepend it with a - or empty string.

| stats count | eval count=-5 | eval duration=if(count<0, "-", "") + tostring(abs(count), "duration")

View solution in original post

0 Karma

joxley
Path Finder

Absolute the duration in the conversion and prepend it with a - or empty string.

| stats count | eval count=-5 | eval duration=if(count<0, "-", "") + tostring(abs(count), "duration")
0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>