Please attach a workbook with Sample data to get help you faster.
No need, just stick all three on a dashboard, independently formatted.
hi i noticed one user belongs to 3 teams?
and what do you want? Making 3 KPIs presenting in one sheet? OR...?
Hi Tian, I think I left some stuff out of the explanation. Let me add those:
a)Abril, Maio and Junho are months - April, May, June.
b) The users are mferreira, fconceicao, ldesousa, bpaiva and pparelo.
c) There's only one team, everything I've sent here is about the same team! Different metrics, same team.
I'll try to explain the end result that I need a little bit better:
Each metric composes a piece of the final grade for each member of this team.
Let's say Above is worth 2 points, Meet is worth 1 point, and Below is worth 0 points.
The weight of each metric is:
Suppose that the metrics for fconceicao in June are as follows:
Knowing that the team's SLA in June was below the required, I need to be able to see this in a single screen:
Team's SLA: Below
fconceicao Grade: Weighted average of all criteria:
0 x 1
2 x 1
0 x 2
so fconceicao's average grade is 2/4 = 0.5
Does this make my problem any clearer?
Hi Peter, how are you?
I have explained my problem further down. The problem is that I need those different pieces of information to interact, as they are eventually used to make a single grade per employee.
Post a .twbx please.
i didn't find the place where i can upload a .twbx, can anybody tell me?
so I post it on the public.
You can have a look and see whether it solves your question.