Splunk Search

How do I use count multiple times in one search?

tcollins93
New Member

How do I use count multiple times in one search?

For example:

search * | stats count by f1, f2 count by f3, f4
Tags (2)
0 Karma

somesoni2
Revered Legend

Without much info, I would suggest this

search * | stats count by f1, f2 f3, f4
| appendpipe [| stats sum(count) as count by f1,f2 | eval keep=1]
| appendpipe [| stats sum(count) as count by f3,f4 | eval keep=1]
| where keep=1

gjanders
SplunkTrust
SplunkTrust

Your question is not very clear, but perhaps you are looking for eventstats?
That would allow you to run multiple stats commands over the data in different ways.

Or perhaps you want to combine your count with an eval statement? Examples are in previous posts or the documentation
The above will allow conditional counting

0 Karma

adonio
Ultra Champion

can you elaborate? maybe add some sample data and use case? if you have an idea of how you would like your results to look like it can also be very beneficial...
to your question, you can count by as many fields you want ... | stats count by f1 f2 f3 .... fN
hope it helps

0 Karma
Get Updates on the Splunk Community!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

  Ready to master Kubernetes and cloud monitoring like the pros?Join Splunk’s Growth Engineering team for an ...

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...