topic Re: count the specific items from the list in Splunk in Splunk Search https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468859#M132009 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/156785">@vnravikumar</a> I think you misunderstood. The temp column I am getting by using stats like below -</P> <P>| stats min(_time) as _time, list(req_content) as temp, count(req_content) as total by uniqueId</P> <P>Now, that temp column has details like above I mentioned in the question. I need another column with the count of /review-basket in the temp column.</P> Wed, 30 Sep 2020 04:54:43 GMT Shashank_87 2020-09-30T04:54:43Z count the specific items from the list in Splunk https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468857#M132007 <P>Hi, I have a list column with different values and i want to count the number of occurence of a specific value. For example I have a column temp which contain list of values like below -</P> <P>temp<BR /> /review-basket<BR /> /review-basket<BR /> /review-basket<BR /> /check-your-details</P> <P>Now what i want another column with a count of the occurence of /review-basket which in the above case is 3.</P> <P>Any help is appreciated.</P> Mon, 06 Apr 2020 09:39:50 GMT https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468857#M132007 Shashank_87 2020-04-06T09:39:50Z Re: count the specific items from the list in Splunk https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468858#M132008 <P>Hi</P> <P>Try with</P> <PRE><CODE>.....|eventstats count by temp </CODE></PRE> Mon, 06 Apr 2020 10:01:53 GMT https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468858#M132008 vnravikumar 2020-04-06T10:01:53Z Re: count the specific items from the list in Splunk https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468859#M132009 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/156785">@vnravikumar</a> I think you misunderstood. The temp column I am getting by using stats like below -</P> <P>| stats min(_time) as _time, list(req_content) as temp, count(req_content) as total by uniqueId</P> <P>Now, that temp column has details like above I mentioned in the question. I need another column with the count of /review-basket in the temp column.</P> Wed, 30 Sep 2020 04:54:43 GMT https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468859#M132009 Shashank_87 2020-09-30T04:54:43Z Re: count the specific items from the list in Splunk https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468860#M132010 <P>@Shashank_87, is your expected output is supposed to look like this?</P> <P>temp count<BR /> /review-basket 3<BR /> /review-basket 3<BR /> /review-basket 3<BR /> /check-your-details 1</P> Mon, 06 Apr 2020 13:30:46 GMT https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468860#M132010 rmmiller 2020-04-06T13:30:46Z Re: count the specific items from the list in Splunk https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468861#M132011 <P>... | stats count by temp</P> Tue, 21 Apr 2020 20:26:59 GMT https://community.splunk.com/t5/Splunk-Search/count-the-specific-items-from-the-list-in-Splunk/m-p/468861#M132011 apoorvaarbooj 2020-04-21T20:26:59Z