All Apps and Add-ons

How To FIND durations of groups of speed ranging in 0 to 5

scool29
Explorer

Hi ,
I have data with 4 fields lat,long,duration and speed . i want to find out durations for groups having speed range 0 to 5.

0 Karma

kristian_kolb
Ultra Champion

You could provide some more information of what results you desire, but this search is one way to "find out durations".

sourcetype=blah speed>=0 speed<=5 | stats values(duration) by speed

You should probably read on some of the reporting commands such as stats, chart, timechart etc.

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Stats
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Timechart
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/CommonStatsFunctions

/K

0 Karma

MuS
Legend
0 Karma

scool29
Explorer

thanks for your answer,below is some detail of exact problem:-

latitude longitude duration speed
18.59094039 73.74169497 11-02-2014 19:42 0.833333
18.59096988 73.74183935 11-02-2014 19:43 1.833333
18.59101222 73.74205194 11-02-2014 19:44 6.666667
18.59101222 73.74205194 11-02-2014 19:44 0.666667
A Group is counted as one when speed >=0 and speed<=5. if speed exceeds 5 then again search for speed>=0 and speed<=5 and count it as 2nd group until speed>5 is found.we want duration for each such group.

0 Karma
Get Updates on the Splunk Community!

Splunk App for Anomaly Detection End of Life Announcment

Q: What is happening to the Splunk App for Anomaly Detection?A: Splunk is officially announcing the ...

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...