Splunk Search

How to find the 3rd/Nth largest value from a field?

zztc2004
Explorer

Is there a function such as max()/min() in Splunk, so that I can find the 3rd/Nth largest value from a field?
For example:
Field:
1
2
3
4
5
6
Output:
function(Field)=4

Thanks
Jay

0 Karma

vinodmaddhuri
New Member

hi
how can we get a colums fileds into row where it is in below format

_Time Scotter delivery Flight dliver Train deliver Count

and i need in

01-2018 Scotter 1560

i need month wise used transport mode

0 Karma

kiril123
Path Finder

I believe you can use mvindex() function to return the Nth element.

0 Karma

zztc2004
Explorer

before using that, I should do sort first, right?
Is there anyway that I can get Nth lagest value without the sort.

Jay

0 Karma
Get Updates on the Splunk Community!

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

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...