Splunk Search

Splunk stats count by two fields

srujan594
Loves-to-Learn

Hi 

Can anyone please help with this extracting stats count by two fields. 

I've below data in each transaction

type                status

A                    200

B                    400

C                    200

B                    200

A                    200

B                    400

A                    500

C                    300

 

I need stats in below format

type              status           count

A                    200                 2

A                   500                  1

B                    200                 1

B                   400                 2                                  

C                 200                   1 

C                 300                   1 

 

Labels (2)
0 Karma

danielcj
Communicator

Hi,

 

Please try the following:

<YOUR_QUERY>
| stats count by type, status
0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...