Splunk Search

Group field value and count rather than overall count

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

Revered Legend

Try this

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

View solution in original post

Revered Legend

Try this

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

View solution in original post

Explorer

That did the trick! Thank you very much!

0 Karma

Legend

Try this..

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

Explorer

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

http://imgur.com/UiTNvK5

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes
and swag!