https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272440#M82018 <P>wow, thank you very much for your help!!!</P> Tue, 25 Oct 2016 20:12:32 GMT splunkrocks2014 2016-10-25T20:12:32Z https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272438#M82016 <P>Hi. I have a search result returned as the following:</P> <PRE><CODE>name type col_1 col_2 col3 ==== ==== ===== ===== ===== N1 T1 A A C N1 T2 A B D N2 T1 D D C </CODE></PRE> <P>How to count numbers of "A", "B", "C", and "D"? For example, the result looks like this:</P> <PRE><CODE>new_field count ========= ===== A 2 B 1 C 2 D 3 </CODE></PRE> <P>Any helps are great appreciated.</P> <P>Thanks.</P> Tue, 25 Oct 2016 19:56:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272438#M82016 splunkrocks2014 2016-10-25T19:56:50Z https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272439#M82017 <P>Try this</P> <PRE><CODE>base search | fields - type | untable name fields values | stats count by values </CODE></PRE> Tue, 25 Oct 2016 20:03:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272439#M82017 sundareshr 2016-10-25T20:03:18Z https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272440#M82018 <P>wow, thank you very much for your help!!!</P> Tue, 25 Oct 2016 20:12:32 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-numbers-of-records-per-category-from-a-table/m-p/272440#M82018 splunkrocks2014 2016-10-25T20:12:32Z