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 *****
Hi chandrashekhardere,
add this to your existing search:
.... | where Speed<="5" OR Speed>"5"
hope this helps ...
cheers, MuS
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?
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 **