How to get unique Maximum value of corresponding field?

[ISP8055]

Hi there, 

I have data like this:

Server	load
A	65
A	50
B	35
C	55
B	45
C	70

I want to get a maximum peak loads of each server type and display in a table format.
So,

Server	Peak load
A	65
B	45
C	70

I need help in how can I do that?

[kamlesh_vaghela · Accepted solution]

@ISP8055 

Can you please try this?

YOUR_SEARCH
| stats max(load) as load by Server

My Sample Search :

| makeresults 
| eval _raw="Server	load
A	65
A	50
B	35
C	55
B	45
C	70" 
| multikv forceheader=1
| table Server 	load
| stats max(load) as load by Server

 Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.