Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help

Hi All, I want to calculate time spent in mm: ss on a specific task (code col) by a specific individual (user id col) and get the sum of the quantity per hour per individual per task.      ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, I have uploaded the table below - the result I am expecting to see the (QTY) productivity of different users based on the time stamp for various activities (CODE COL) for specific dates and weeks and QTR, and also want to calculate the KPI percentage based on the QTY target of 130 per hour.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      please try again - nothing attached.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago
        ACTIVITY DATECODEUSER_IDDATE_TIMESTAMPQTY
        1/06/2023PickELLA8:47:45 am1
        1/06/2023PickELLA8:48:54 am1
        1/06/2023PickELLA8:49:18 am1
        1/06/2023PickKGREY9:46:33 am1
        1/06/2023PickELLA9:55:12 am1
        1/06/2023PickELLA9:56:08 am1
        1/06/2023PickELLA9:58:13 am1
        1/06/2023PickELLA9:59:21 am1
        1/06/2023PickELLA10:00:09 am1
        1/06/2023ReceiptKGREY13:58:32 PM35
        1/06/2023ReceiptKGREY13:58:44 PM38
        1/06/2023PutawayKGREY13:59:10 PM15
        1/06/2023PutawayKGREY13:59:22 PM26
        1/06/2023PutawayKGREY13:59:26 PM35
        1/06/2023PutawayKGREY13:59:38 PM38
        1/06/2023PutawayKGREY13:59:47 PM26
        1/06/2023PickNIVAN14:01:59 PM1
        1/06/2023PickNIVAN14:03:15 PM1
        1/06/2023PickNIVAN14:04:07 PM1
        1/06/2023PickNIVAN14:04:39 PM1
        1/06/2023PickNIVAN14:08:52 PM1
        1/06/2023PickNIVAN14:09:52 PM1
        1/06/2023PutawayELLA14:14:38 PM2
        1/06/2023PutawayELLA14:15:14 PM4
        1/06/2023PickNIVAN14:22:46 PM1
        1/06/2023PickNIVAN14:24:23 PM1
        1/06/2023ReceiptNIVAN14:24:56 PM1
        1/06/2023ReceiptNIVAN14:27:25 PM6
        1/06/2023PutawayKGREY14:33:12 PM21
        1/06/2023PutawayKGREY14:33:20 PM33
        1/06/2023PickNIVAN14:33:28 PM1
        1/06/2023PutawayKGREY14:33:28 PM30
        2/06/2023PutawayEPEV6:54:17 am2
        2/06/2023PutawayEPEV6:54:30 am2
        2/06/2023PutawayEPEV6:56:22 am6
        2/06/2023PutawayEPEV6:57:10 am3
        2/06/2023PutawayEPEV6:57:14 am1
        2/06/2023PickELLA6:57:58 am1
        2/06/2023PickELLA6:59:30 am1
        2/06/2023PickKGREY6:59:46 am2
        2/06/2023PickKGREY7:00:02 am3
        2/06/2023PickELLA7:26:01 am1
        2/06/2023PickELLA7:56:29 am1
        2/06/2023PickKGREY7:56:37 am2
        2/06/2023PickKGREY7:56:57 am1
        2/06/2023PickELLA7:57:33 am1
        2/06/2023PickKGREY7:57:53 am1
        2/06/2023PickELLA8:48:29 am1
        2/06/2023PickKGREY8:49:17 am1
        2/06/2023PickKGREY8:49:53 am1
        2/06/2023PickELLA8:50:29 am1
        2/06/2023PickELLA8:58:04 am1
        2/06/2023PickKGREY8:58:28 am1
        2/06/2023ReceiptKGREY10:42:43 am6
        2/06/2023ReceiptKGREY10:49:07 am18
        2/06/2023ReceiptKGREY10:49:30 am18
        2/06/2023ReceiptKGREY10:49:50 am18
        2/06/2023ReceiptKGREY10:50:03 am30
        2/06/2023ReceiptKGREY10:50:22 am42
        2/06/2023ReceiptKGREY10:50:37 am72
        2/06/2023ReceiptKGREY10:50:53 am84
        2/06/2023ReceiptKGREY10:51:08 am120
        2/06/2023ReceiptKGREY10:51:30 am186
        2/06/2023PutawayKGREY11:03:18 am18
        2/06/2023PutawayKGREY11:03:30 am72
        2/06/2023PutawayKGREY11:03:34 am120
        2/06/2023PutawayKGREY11:04:54 am6
        2/06/2023ReceiptELLA11:35:51 am18