Splunk Search

Adding an event field to Stats Min command

petem3
New Member

When calculating a minimum value across events how can you then retain an event field related to the minimum value and display the minimum value with the event field?   

Labels (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust
| eventstats min(field) as min_field
| where field=min_field
| table _time, field
————————————
If this helps, give a like below.
0 Karma

petem3
New Member

I am trying to show the event date related to the min field value, along with the minimum value. 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It would help to see your current query, but I think you want to try the eventstats command.

---
If this reply helps you, Karma would be appreciated.
0 Karma

thambisetty
SplunkTrust
SplunkTrust

eventstats 

| eventstats min(fieldname) 

https://youtu.be/vq3h9Qo5UPY

————————————
If this helps, give a like below.
0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...