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
SplunkTrust
SplunkTrust
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!

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...

Want to Reduce Costs, Mitigate Risk, Improve Performance, or Increase Efficiencies? ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...