Hello,
I'm looking for help on creating a measure that give me an overall score based off of other score Metrics.
I have 2 tables:
First table provides the employee scores for the metrics being measured:
<tbody>
</tbody>
Second Table provides the % weight for each of the metrics being measured above to calculate an overall score: (notice how Baltimore doesnt have and Adherence % above - They also dont Adherence in the table below because they are not measured on it).
<tbody>
</tbody>
I'm looking for help on how to create a measure that will caculate the Overall % based on the 2 tables above so that its using the correct Scoring Weight%. There are many more offices with different variations of the %'s so I'd need this to be able to look at the RankGroup to determine the correct % to be used.
Appreciate the help!
I'm looking for help on creating a measure that give me an overall score based off of other score Metrics.
I have 2 tables:
First table provides the employee scores for the metrics being measured:
dDate | RankGroup | Full Name | Production% | Quality% | Adherence% |
Friday, June 28, 2019 | Baltimore | Mickey Mouse | 106% | 100% | |
Thursday, June 27, 2019 | Baltimore | Mickey Mouse | 111% | 100% | |
Monday, July 1, 2019 | Baltimore | Mickey Mouse | 110% | 100% | |
Monday, July 1, 2019 | Mesa | Donald Duck | 97% | 100% | 94% |
Thursday, June 27, 2019 | Mesa | Donald Duck | 130% | 100% | 50% |
Friday, June 28, 2019 | Mesa | Donald Duck | 72% | 100% | 94% |
<tbody>
</tbody>
Second Table provides the % weight for each of the metrics being measured above to calculate an overall score: (notice how Baltimore doesnt have and Adherence % above - They also dont Adherence in the table below because they are not measured on it).
RankGroup | Metric | Scoring Weight | Old/Current Metric |
Baltimore | Quality | 60% | Current |
Baltimore | POP | 40% | Current |
Mesa | Schedule Adherence | 10% | Current |
Mesa | Quality | 50% | Current |
Mesa | POP | 40% | Current |
<tbody>
</tbody>
I'm looking for help on how to create a measure that will caculate the Overall % based on the 2 tables above so that its using the correct Scoring Weight%. There are many more offices with different variations of the %'s so I'd need this to be able to look at the RankGroup to determine the correct % to be used.
Appreciate the help!