Splunk Search

Group field value and count rather than overall count

emamedov
Explorer

eventtype="product-view"|stats count list(productname) as Products by username firmname

The above is the search string that I'm using and I receive the following results:

alt text

Instead of listing an overall count of products, I would like to have a count for each individual product. Not sure how to edit the current string or add a nested stats string to accomplish the said task.

0 Karma
1 Solution

somesoni2
Revered Legend

Try this

eventtype="product-view"|stats count by username firmname,productname | stats list(*) as * by username firmname

View solution in original post

somesoni2
Revered Legend

Try this

eventtype="product-view"|stats count by username firmname,productname | stats list(*) as * by username firmname

emamedov
Explorer

That did the trick! Thank you very much!

0 Karma

sundareshr
Legend

Try this..

eventtype="product-view"|stats count by productname
0 Karma

emamedov
Explorer

That doesn't specifically display the username and firmname though. Please see below:

http://imgur.com/UiTNvK5

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...