Tracking KPIs per Reps across multiple weeks

[Ryanb2412]

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.

[v-shex-msft]

Hi @Ryanb2412,

AFAIK, card visual not suitable for your requirement. Currently, it only allows you to use one field in it to display the aggregate value. Even if you select multiple items on the slicer, it also displays one aggregate value of selected items.

Since we not so clarify your data structure, can you please share some dummy data to test and coding formula?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng