There’s a search table with search criteria - from date, to date, name of project.
The search returns rows (based on a slice) from a table with user names and if they attended or not a session or not, filtered by ‘from’ and ‘to’ dates and name of project. That means a person can have multiple instances (comprising of both yes and no) within a date range. And there can be multiple persons within a date range.
I want to have a report triggered by change from the search table, that outputs in a table the unique persons within that inputted date range and their corresponding attended percentage (count of all attended records by that person / count of all records by that person within that date range).
I can have all the persons printed out and would make sure that one name is not repeated (since there can be multiple instances of the same person within a date range) by using the unique() function. But how can I get to count their corresponding attendance records?