With some help from you guys Im getting there now and i require one more piece of your help.
I now have the dates and times my employees come in through the gate at work, and the expected working times they are expected to be productive.
What i want to do now is measure the expected productive hours against what they actually clock in the SAP system and measure their utilization percentages. the target is a minimum of 85% per day and i want to show that for each employee in a bar graph.
Expected Hours & Minutes Inside (Measure) = The expected times the should show SAP clocking’s for. for example if they clock 8 hours on that day its 100% utilized if they clock 6.8 hours that’s 85% which is the minimum expected target per day.
Im struggling to get the measure correct from the COOIS table for the actual clocked durations in SAP. i created a measure called COOIS Clocking but doesn’t appear to pick up correctly in the table
I then want to then calculate the utilization using the expected working time / Actual clocking using the measure Utilization %
Strata Staff Utilization.pbix (1.9 MB)
Thanks for all your help