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!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...