I have a table which consists of Company Name, Employee Name, StartDate, Exercise_id. I need to find count of all the Employee who have started atleast one exercise this month (i.e. emplyee should only be consider if his exercise count within this month is > 0 else don't consider this employee)
What I have tried till now is:
Using Expression editor:
Count(Aggr(Count(exercise_id), employee_name))
But I am not sure how to ignore Employee with no exercise count and how to group by month (and I'm planning to add a variable input which will act as my month selector value i.e. for which month I need to find count)
