Splunk Search

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

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