Splunk Search

dedup maximum value

reverse
Contributor

Assuming there are 2 columns - Date & count and there are duplicates date.

How to dedup on Date and pick the maximum count value ?

2020-02-27  1522
2020-02-27  1680
2020-02-28  1639
2020-02-28  1639
2020-02-29  5
2020-02-29  5

Please guide.

Tags (1)
0 Karma
1 Solution

to4kawa
Ultra Champion
your search
|sort 0 - count
| dedup Date

View solution in original post

to4kawa
Ultra Champion
your search
|sort 0 - count
| dedup Date

reverse
Contributor

thank you .. worked like a charm!!!

0 Karma

reverse
Contributor

@Vijeta - buddy .. you around ?

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Synthetic Monitoring - Resolved Incident on Detector Alerts

We’ve discovered a bug that affected the auto-clear of Synthetic Detectors in the Splunk Synthetic Monitoring ...

Video | Tom’s Smartness Journey Continues

Remember Splunk Community member Tom Kopchak? If you caught the first episode of our Smartness interview ...

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud?

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud? Learn how unique features like ...