Aug 25 2021 12:29 AM - edited Aug 25 2021 12:34 AM
hi,
I want to create KPI based on three factors. example employees are performing multiple functions but at the end of the day i need each employee to perform 100% during his/her 8 hours.
example - putaway 15 skids/hour - replenishment 10 skids/hour - picking 26 lines/hour. the combination of all this must be 100%.
please help me get there if you can.
thank you
Aug 25 2021 03:21 AM - edited Aug 26 2021 12:30 AM
this is typical example
8/23/2021 PUTAWAY Operator 1 - 3 skids
8/23/2021 REPLENISHMENT Operator 1 - 11 skids
8/23/2021 Order PICKING Operator 1- 14 lines
Aug 26 2021 08:46 PM
Aug 27 2021 08:02 AM
It all depends on how your data is structured, much better to have sample file.
If you have separate table with targets of skids/lines for each activity, you may add helper column to main data which transforms actual skids/lines into hours or percentage of target. When you may aggregate your data by PivotTable to show data for each employee/operator for each date.