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