topic Re: How to group and count together the rows based on some field value in splunk? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-group-and-count-together-the-rows-based-on-some-field/m-p/420556#M120862 <P>Like this:</P> <PRE><CODE>| stats values(custID) count(custID) dc(custID) BY eventID </CODE></PRE> Thu, 05 Jul 2018 04:58:21 GMT woodcock 2018-07-05T04:58:21Z How to group and count together the rows based on some field value in splunk? https://community.splunk.com/t5/Splunk-Search/How-to-group-and-count-together-the-rows-based-on-some-field/m-p/420555#M120861 <P>Example:<BR /> I am having a search in my view code and displaying results in the form of table.<BR /> small example result:<BR /> custid Eventid<BR /> 10001 200<BR /> 10001 300<BR /> 10002 200<BR /> 10002 100<BR /> 10002 300</P> <P>I got the answer for grouping of the custid's by using the query "stats values(custID) by eventID". I also need to count the custID that has occurred for every Customer. Can anyone suggest me the query for the same? Whatever I use apart from the above query to count the number of custid's I could not get the answers for the same.</P> Thu, 05 Jul 2018 04:28:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-group-and-count-together-the-rows-based-on-some-field/m-p/420555#M120861 gokikrishnan198 2018-07-05T04:28:39Z Re: How to group and count together the rows based on some field value in splunk? https://community.splunk.com/t5/Splunk-Search/How-to-group-and-count-together-the-rows-based-on-some-field/m-p/420556#M120862 <P>Like this:</P> <PRE><CODE>| stats values(custID) count(custID) dc(custID) BY eventID </CODE></PRE> Thu, 05 Jul 2018 04:58:21 GMT https://community.splunk.com/t5/Splunk-Search/How-to-group-and-count-together-the-rows-based-on-some-field/m-p/420556#M120862 woodcock 2018-07-05T04:58:21Z