MSCM - Global Reports measures
Efficiency Tracking
Activity Log
| Measure name | Source table / calculation |
|---|---|
| Activity Count Per Hour | Activity Log Count/Activity Duration |
| Activity Duration |
DATEDIFF(MSCM_ACTIVITY_LOG.START_TIME,MSCM_ACTIVITY_LOG.END_TIME) In seconds |
| Activity Log Count | Count of MSCM_ACTIVITY_LOG.ACTIVITY_LOG_ID |
| Activity Log Operator Count | Distinct Count of MSCM_ACTIVITY_LOG.USER_ID |
| Activity Quantity | MSCM_ACTIVITY_LOG.QUANTITY |
| Activity Sub Unit | MSCM_ACTIVITY_LOG.SUB_UNIT |
| Average Activity per Operator | Activity Log Count / Distinct Activity Log Operator Count |
| Average Man Hours | Activity Duration / Distinct Activity Log Operator Count |
| Average Man Hours per Activity | Activity Duration / Activity Log Count |
| Man Hour Time | Activity Duration in hh:mm:ss format |
| Man Hours | Activity Duration / 3600 |