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
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.

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        You need to provide better sample data for that.