Need help

Question

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.&nbsp;&nbsp;&nbsp;Thanks in advance

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

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 · Answer

please try again - nothing attached.

anonymous · Answer

ACTIVITY DATECODEUSER_IDDATE_TIMESTAMPQTY1/06/2023PickELLA8:47:45 am11/06/2023PickELLA8:48:54 am11/06/2023PickELLA8:49:18 am11/06/2023PickKGREY9:46:33 am11/06/2023PickELLA9:55:12 am11/06/2023PickELLA9:56:08 am11/06/2023PickELLA9:58:13 am11/06/2023PickELLA9:59:21 am11/06/2023PickELLA10:00:09 am11/06/2023ReceiptKGREY13:58:32 PM351/06/2023ReceiptKGREY13:58:44 PM381/06/2023PutawayKGREY13:59:10 PM151/06/2023PutawayKGREY13:59:22 PM261/06/2023PutawayKGREY13:59:26 PM351/06/2023PutawayKGREY13:59:38 PM381/06/2023PutawayKGREY13:59:47 PM261/06/2023PickNIVAN14:01:59 PM11/06/2023PickNIVAN14:03:15 PM11/06/2023PickNIVAN14:04:07 PM11/06/2023PickNIVAN14:04:39 PM11/06/2023PickNIVAN14:08:52 PM11/06/2023PickNIVAN14:09:52 PM11/06/2023PutawayELLA14:14:38 PM21/06/2023PutawayELLA14:15:14 PM41/06/2023PickNIVAN14:22:46 PM11/06/2023PickNIVAN14:24:23 PM11/06/2023ReceiptNIVAN14:24:56 PM11/06/2023ReceiptNIVAN14:27:25 PM61/06/2023PutawayKGREY14:33:12 PM211/06/2023PutawayKGREY14:33:20 PM331/06/2023PickNIVAN14:33:28 PM11/06/2023PutawayKGREY14:33:28 PM302/06/2023PutawayEPEV6:54:17 am22/06/2023PutawayEPEV6:54:30 am22/06/2023PutawayEPEV6:56:22 am62/06/2023PutawayEPEV6:57:10 am32/06/2023PutawayEPEV6:57:14 am12/06/2023PickELLA6:57:58 am12/06/2023PickELLA6:59:30 am12/06/2023PickKGREY6:59:46 am22/06/2023PickKGREY7:00:02 am32/06/2023PickELLA7:26:01 am12/06/2023PickELLA7:56:29 am12/06/2023PickKGREY7:56:37 am22/06/2023PickKGREY7:56:57 am12/06/2023PickELLA7:57:33 am12/06/2023PickKGREY7:57:53 am12/06/2023PickELLA8:48:29 am12/06/2023PickKGREY8:49:17 am12/06/2023PickKGREY8:49:53 am12/06/2023PickELLA8:50:29 am12/06/2023PickELLA8:58:04 am12/06/2023PickKGREY8:58:28 am12/06/2023ReceiptKGREY10:42:43 am62/06/2023ReceiptKGREY10:49:07 am182/06/2023ReceiptKGREY10:49:30 am182/06/2023ReceiptKGREY10:49:50 am182/06/2023ReceiptKGREY10:50:03 am302/06/2023ReceiptKGREY10:50:22 am422/06/2023ReceiptKGREY10:50:37 am722/06/2023ReceiptKGREY10:50:53 am842/06/2023ReceiptKGREY10:51:08 am1202/06/2023ReceiptKGREY10:51:30 am1862/06/2023PutawayKGREY11:03:18 am182/06/2023PutawayKGREY11:03:30 am722/06/2023PutawayKGREY11:03:34 am1202/06/2023PutawayKGREY11:04:54 am62/06/2023ReceiptELLA11:35:51 am18

lbendlin · Answer

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

&nbsp;
Then the report writes itself.

see attached
&nbsp;
&nbsp;

Forum Discussion

Need help

7 Replies