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 **
... View more