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!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...