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!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...