Make a count on a list of values

Elastic Stack Elasticsearch
1

Hello,

I want to create a query that will count the appearance of every value in a list of values.

example:

each line represents a different doc:

|doc_id|Name|
|1|Sam|
|2|Dan|
|3|Sam|
|4|Sam|
|5|Billy|
|6|Billy|
|7|John|

and I have the following list - [John, Billy, Sam]
I want the output to be:

|John|1|
|Billy|2|
|Sam|3|

Is this possible?

Alon

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.