Hey All,
I am trying to track average compliance for each person per week. This is kind of tricky because I also would like it to take the average compliance over multiple weeks if I select multiple weeks in the filter. I am displaying the count of compliant vs non-compliant in 2 cards. For example:
Person 1 Average Compliance:
- Week 1: 100%
- Week 2: 50%
- Week 3: 90%
Person 2 Average Compliance:
- Week 1: 95%
- Week 2: 10%
- Week 3: person quit job so had no data for this week
If the key metric is to have compliance >= to 90%, Person 1 would be compliant in week 1 & week 3 so he would be counted in the compliant card when either of those weeks are selected. When I select all 3 weeks in the filter, the average compliance should be 80% so he would show in the non-compliant card for those weeks. Similarly, person 2 would show compliant in week 1, non-compliant if week 1, 2, & 3 are selected even though he is no longer active during week 3.
Any help would be greatly appreciated.
