Search query - where after stats count command

[shayhibah]

I'm trying to count the value of "name" field and to show results only where the count is greater than 1.

My query is: | stats count by name| where count > 1

What am I missing? 😮

Thanks

[martin_mueller]

The search looks correct if you want "count events for each value of the name field, and only show name field values that occur more than once".

If that's not what you're looking for, do elaborate more what your actual use case is.

[martin_mueller]

Got a screenshot that includes your search and results with count=1?

[shayhibah]

Thats exatcly what I want.
The problem is that I can find events on the results that their count equals to 1.