Splunk Search

How to display a value of zero in a chart for negative values returned in a search?

tohalan
New Member

Hi Everyone,

Need some help on how to display the output value as zero in a chart when a negative result is returned.

Thank you
Kind regards,

Tags (2)
0 Karma

javiergn
Super Champion

If I understand correctly, you just want to return 0 if the value is negative, right?
If that's the case:

your base search
| eval myNewValue = if(oldValue < 0, 0, oldValue)
| chart foo bar by myNewValue

If not please provide an example

0 Karma

tohalan
New Member

Bingo, thanks a lot and it works

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...