Make a count on a list of values


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


each line represents a different doc:


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


Is this possible?


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