Splunk Search

How do I get the max from each column?

HattrickNZ
Motivator

With a search like ....| eval Field3=Field1+Field3

I have data as follows(in the stats tab):

_time   Field1  Field2  Field3
2015-05-11 00:00    915.426122  698.086667  217.33945530
2015-05-11 01:00    593.966923  462.311111  131.65581163
2015-05-11 02:00    403.424360  319.715556  83.708804253
2015-05-11 03:00    327.785973  261.006667  66.779305556 
.
.
.

how do I get the max of each column?

I am thinking something like addcoltotalsbut that gets the sum of the columns but I want the max.

Labels (1)
Tags (2)
0 Karma
1 Solution

MuS
Legend

Hi HattrickNZ,

how about something like this:

.... | eval Field1=Field2+Field3 | stats max(Field1) AS Field1 max(Field2) AS Field2 max(Field3) AS Field3 by _time

It looks like you're adding up Field2 + Field3 so I changed it in above search.

Hope this helps ....

cheers, MuS

View solution in original post

jotne
Builder

If you have may fields and do not know the name of them or variable number of fields, you can run it like this:

| stats max(*) as max_*
0 Karma

MuS
Legend

Hi HattrickNZ,

how about something like this:

.... | eval Field1=Field2+Field3 | stats max(Field1) AS Field1 max(Field2) AS Field2 max(Field3) AS Field3 by _time

It looks like you're adding up Field2 + Field3 so I changed it in above search.

Hope this helps ....

cheers, MuS

HattrickNZ
Motivator

easy as that, tks.

0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...