Need help

[RAV_RAV]

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.

Thanks in advance

[lbendlin]

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

[RAV_RAV]

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]

please try again - nothing attached.

[RAV_RAV]

ACTIVITY DATE	CODE	USER_ID	DATE_TIMESTAMP	QTY
1/06/2023	Pick	ELLA	8:47:45 am	1
1/06/2023	Pick	ELLA	8:48:54 am	1
1/06/2023	Pick	ELLA	8:49:18 am	1
1/06/2023	Pick	KGREY	9:46:33 am	1
1/06/2023	Pick	ELLA	9:55:12 am	1
1/06/2023	Pick	ELLA	9:56:08 am	1
1/06/2023	Pick	ELLA	9:58:13 am	1
1/06/2023	Pick	ELLA	9:59:21 am	1
1/06/2023	Pick	ELLA	10:00:09 am	1
1/06/2023	Receipt	KGREY	13:58:32 PM	35
1/06/2023	Receipt	KGREY	13:58:44 PM	38
1/06/2023	Putaway	KGREY	13:59:10 PM	15
1/06/2023	Putaway	KGREY	13:59:22 PM	26
1/06/2023	Putaway	KGREY	13:59:26 PM	35
1/06/2023	Putaway	KGREY	13:59:38 PM	38
1/06/2023	Putaway	KGREY	13:59:47 PM	26
1/06/2023	Pick	NIVAN	14:01:59 PM	1
1/06/2023	Pick	NIVAN	14:03:15 PM	1
1/06/2023	Pick	NIVAN	14:04:07 PM	1
1/06/2023	Pick	NIVAN	14:04:39 PM	1
1/06/2023	Pick	NIVAN	14:08:52 PM	1
1/06/2023	Pick	NIVAN	14:09:52 PM	1
1/06/2023	Putaway	ELLA	14:14:38 PM	2
1/06/2023	Putaway	ELLA	14:15:14 PM	4
1/06/2023	Pick	NIVAN	14:22:46 PM	1
1/06/2023	Pick	NIVAN	14:24:23 PM	1
1/06/2023	Receipt	NIVAN	14:24:56 PM	1
1/06/2023	Receipt	NIVAN	14:27:25 PM	6
1/06/2023	Putaway	KGREY	14:33:12 PM	21
1/06/2023	Putaway	KGREY	14:33:20 PM	33
1/06/2023	Pick	NIVAN	14:33:28 PM	1
1/06/2023	Putaway	KGREY	14:33:28 PM	30
2/06/2023	Putaway	EPEV	6:54:17 am	2
2/06/2023	Putaway	EPEV	6:54:30 am	2
2/06/2023	Putaway	EPEV	6:56:22 am	6
2/06/2023	Putaway	EPEV	6:57:10 am	3
2/06/2023	Putaway	EPEV	6:57:14 am	1
2/06/2023	Pick	ELLA	6:57:58 am	1
2/06/2023	Pick	ELLA	6:59:30 am	1
2/06/2023	Pick	KGREY	6:59:46 am	2
2/06/2023	Pick	KGREY	7:00:02 am	3
2/06/2023	Pick	ELLA	7:26:01 am	1
2/06/2023	Pick	ELLA	7:56:29 am	1
2/06/2023	Pick	KGREY	7:56:37 am	2
2/06/2023	Pick	KGREY	7:56:57 am	1
2/06/2023	Pick	ELLA	7:57:33 am	1
2/06/2023	Pick	KGREY	7:57:53 am	1
2/06/2023	Pick	ELLA	8:48:29 am	1
2/06/2023	Pick	KGREY	8:49:17 am	1
2/06/2023	Pick	KGREY	8:49:53 am	1
2/06/2023	Pick	ELLA	8:50:29 am	1
2/06/2023	Pick	ELLA	8:58:04 am	1
2/06/2023	Pick	KGREY	8:58:28 am	1
2/06/2023	Receipt	KGREY	10:42:43 am	6
2/06/2023	Receipt	KGREY	10:49:07 am	18
2/06/2023	Receipt	KGREY	10:49:30 am	18
2/06/2023	Receipt	KGREY	10:49:50 am	18
2/06/2023	Receipt	KGREY	10:50:03 am	30
2/06/2023	Receipt	KGREY	10:50:22 am	42
2/06/2023	Receipt	KGREY	10:50:37 am	72
2/06/2023	Receipt	KGREY	10:50:53 am	84
2/06/2023	Receipt	KGREY	10:51:08 am	120
2/06/2023	Receipt	KGREY	10:51:30 am	186
2/06/2023	Putaway	KGREY	11:03:18 am	18
2/06/2023	Putaway	KGREY	11:03:30 am	72
2/06/2023	Putaway	KGREY	11:03:34 am	120
2/06/2023	Putaway	KGREY	11:04:54 am	6
2/06/2023	Receipt	ELLA	11:35:51 am	18

[lbendlin]

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

Then the report writes itself.

see attached

[RAV_RAV]

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]

You need to provide better sample data for that.