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.
... | stats count by temp
Hi
Try with
.....|eventstats count by temp
@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.
@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