Count or filter-out unique fields

[psarras]

Hi there,

so I have a lot of meeting notes, where I kept track on participants. I was thinking it would be useful if I got a list of all the participants from a specific set of meetings (often they represent people related to a project). So I am doing something like that

Table people
WHERE contains(category, "meeting")
WHERE contains(project,[[project_name]])
flatten people
sort sort(people)

Now, this gives kinda what I want but it would be nice if I can get the names only once i.e. unique list based on the people or for extra points if I can sort them by the number of occurrences and have this displayed as an extra column. i.e

participants	occurances
Stam	5
Joe	2

[AB1908]

I think you're looking for group by. Look at #1033 as well.

[psarras]

Can you rename the "Group" on the first column? to "name" or something?

[psarras]

ah nvm i think you mean to delete the id and then add it separately. This is my final one for brevity

Table without id people as "name", length(rows) as "occurance"
WHERE contains(category, "meeting")
WHERE contains(project,[[project_name]])
flatten people
group by people