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!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...