Splunk Search

How to count numbers of records per category from a table?

splunkrocks2014
Communicator

Hi. I have a search result returned as the following:

name   type   col_1   col_2   col3
====   ====   =====   =====   =====
N1     T1      A        A       C
N1     T2      A        B       D
N2     T1      D        D       C

How to count numbers of "A", "B", "C", and "D"? For example, the result looks like this:

new_field    count
=========    =====
A             2
B             1
C             2
D             3

Any helps are great appreciated.

Thanks.

0 Karma
1 Solution

sundareshr
Legend

Try this

base search | fields - type | untable name fields values | stats count by values

View solution in original post

0 Karma

sundareshr
Legend

Try this

base search | fields - type | untable name fields values | stats count by values
0 Karma

splunkrocks2014
Communicator

wow, thank you very much for your help!!!

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...