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!

Splunk Enterprise Security 8.0.2 Availability: On cloud and On-premise!

A few months ago, we released Splunk Enterprise Security 8.0 for our cloud customers. Today, we are excited to ...

Logs to Metrics

Logs and Metrics Logs are generally unstructured text or structured events emitted by applications and written ...

Developer Spotlight with Paul Stout

Welcome to our very first developer spotlight release series where we'll feature some awesome Splunk ...