count the specific items from the list in Splunk

[Shashank_87]

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 -

temp
/review-basket
/review-basket
/review-basket
/check-your-details

Now what i want another column with a count of the occurence of /review-basket which in the above case is 3.

Any help is appreciated.

[apoorvaarbooj]

... | stats count by temp

[vnravikumar]

Hi

Try with

.....|eventstats count by temp

[Shashank_87]

@vnravikumar I think you misunderstood. The temp column I am getting by using stats like below -

| stats min(_time) as _time, list(req_content) as temp, count(req_content) as total by uniqueId

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.

[rmmiller]

@Shashank_87, is your expected output is supposed to look like this?

temp count
/review-basket 3
/review-basket 3
/review-basket 3
/check-your-details 1