Splunk Search

issue : splunk query is not displying correct result for negative number in range between min(-10) to max(-7)

PCIIT
New Member

Hi ,
we have one field Score which contain floating poiint value(score)

score
-9.5

-9.4

-9.3

-9.0

-8.9

-8.7

-7.9

-7.8

-7.7

-7.6

-7.4

-7.2

-7.1

-7.0

-6.9

-6.6
-5.9

-5.8

-5.7

-5.5

-5.3

-5.0

-4.9

-4.8

-4.7

-4.5

-4.4

-4.3

-4.2

-4.1

-4.0

-3.9

-3.8

-3.7

-3.4

-3.2

-3.0

-2.8

-2.7

-2.5

-2.4

-2.3

-2.1

-1.9

-1.8

I wrote splunk query like
FILTER score >= -10
FILTER score <= -7
SPLITROW score
output :

-6.9

-6.6
-5.9

-5.8

-5.7

-5.5

-5.3

-5.0

-4.9

-4.8

-4.7

-4.5

-4.4

-4.3

-4.2

-4.1

-4.0

-3.9

-3.8

-3.7

-3.4

-3.2

-3.0

-2.8

-2.7

-2.5

-2.4

-2.3

-2.1

score is not displaying proper value for negative number as I have set range between -10 to -7

Tags (2)
0 Karma
Get Updates on the Splunk Community!

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...