All Apps and Add-ons

need data from parameters between ranges

chandrashekhard
New Member

i have a data in csv, having date and speed columns. I want the count for group of continuous speed having speed<=5 till speed > 5 for particular date. In below example, 1 event on date 13.
2 events for date 14 as speed > 5 2 times
e.g-
Date Speed
13-01-2014 21:30 0.000079
13-01-2014 21:30 0
14-01-2014 16:21 0.106243
14-01-2014 16:21 0
14-01-2014 16:21 3.058264
14-01-2014 16:21 3.49649
14-01-2014 16:21 7.904396 *****
14-01-2014 16:21 1.370253
14-01-2014 16:21 3.39984
14-01-2014 16:21 8.904396 *****

0 Karma

MuS
Legend

Hi chandrashekhardere,

add this to your existing search:

.... | where Speed<="5" OR Speed>"5"

hope this helps ...

cheers, MuS

0 Karma

MuS
Legend

okay missed the count - sorry ... as example try this:

index=_internal earliest=-60m | where ( kbps<= "0.001" OR kbps > "0.07" ) | stats count by kbps

this will search all kbps under 0.001 or over 0.07 and count the occurrence per kbps. Does that make sense?

0 Karma

chandrashekhard
New Member

thanks for the reply.... but we already tried same, it gives total number of events, this is not as per our result. we need the count for group of events for speed<=5 and when speed>5 then event should count as 1 and so on...
like for 14 feb: 0.106243 to 3.49649 event as 1 then speed>5 then again 1.370253 to 3.39984: event 2 and so on

14-01-2014 16:21 0.106243
14-01-2014 16:21 0
14-01-2014 16:21 3.058264
14-01-2014 16:21 3.49649

14-01-2014 16:21 7.904396 **

14-01-2014 16:21 1.370253
14-01-2014 16:21 3.39984
14-01-2014 16:21 8.904396 **

0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...