I’ve tried to search this forum for solutions, but I think I need someone to explain it to me like I’m 5. LOL
I have a list of PEOPLE that have participated in training COURSES. Each COURSE is grouped by course CATEGORY. I need to know how many UNIQUE PEOPLE have participated in each course CATEGORY.
example: Mary attended AM2 course and AM3 course in Absence Category. Need the unique count to return “1” attendee in the Absence Category.
I’ve tried the arrayjoin function and I can get the count. Can also get the count by grouping by category.
Appreciate your help!!