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
    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Create a couple of dimensions from your data to build a suitable data model

       

       

      Then the report writes itself.

      see attached

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        i get that thanks, how can i calculate the weekly, daily,monthly averages for individuals and for all the users combined? Also, in percentage considering the target is 130 per hour.