numbers of hours per week

[capriconuser]

I have this kind of data 

script :

LOAD Id, 
OwnerName, 
Date(AttendanceDay,'DD/MM/YYYY') as AttendanceDay, 
Month(AttendanceDay) as AttendanceMonth,
Year(AttendanceDay) as AttendanceYear,
Week(AttendanceDay) as Week,

Working_hours 

FROM
ar_sheet.xlsx
(ooxml, embedded labels, table is report);

i want to extract numbers of hours per week , per month and per year ..

 how i do this 

AttendanceDay	WorkingHours
11/19/2019	09:00
11/19/2019	09:00
11/19/2019	09:00
11/19/2019	0:00
11/18/2019	8:14
11/18/2019	6:53
11/18/2019	0:00
11/18/2019	10:42
11/18/2019	9:29
11/18/2019	09:00
11/18/2019	09:00
11/18/2019	8:33
11/18/2019	9:33
11/17/2019	8:16
11/17/2019	10:52
11/17/2019	10:18
11/17/2019	10:56
11/17/2019	8:31
11/17/2019	10:40
11/14/2019	0:00
11/14/2019	10:00
11/14/2019	8:53
11/14/2019	8:53
11/14/2019	9:21
11/14/2019	9:02
11/14/2019	9:27
11/14/2019	7:29
11/14/2019	8:31
11/14/2019	8:40
11/14/2019	9:53
11/14/2019	8:37
11/14/2019	8:43
11/14/2019	9:09
11/14/2019	9:11
11/14/2019	9:21
11/14/2019	8:54
11/14/2019	10:01
11/14/2019	8:43
11/14/2019	0:00
11/14/2019	9:11
11/14/2019	8:55
11/14/2019	9:09
11/14/2019	8:52
11/14/2019	8:00
11/14/2019	8:52
11/14/2019	8:40
11/14/2019	9:26
11/14/2019	9:04
11/14/2019	0:00
11/14/2019	9:13
11/14/2019	6:03
11/14/2019	8:32
11/14/2019	8:09
11/14/2019	8:46
11/14/2019	10:00
11/14/2019	4:18
11/13/2019	0:00
11/11/2019	9:29
11/12/2019	8:37
11/13/2019	8:57
11/12/2019	8:51
11/11/2019	8:35
11/12/2019	8:44
11/13/2019	8:29
11/12/2019	7:39
11/11/2019	8:07
11/12/2019	8:34
11/13/2019	9:08
11/11/2019	0:00
11/12/2019	9:58
11/13/2019	8:20
11/11/2019	7:53
11/13/2019	8:54
11/11/2019	9:54
11/12/2019	0:00
11/13/2019	10:44
11/12/2019	9:12
11/11/2019	9:55
11/12/2019	7:32
11/13/2019	8:57
11/11/2019	0:00
11/12/2019	8:51
11/11/2019	9:20
11/12/2019	9:44
11/13/2019	9:36
11/11/2019	0:00
11/13/2019	7:27
11/11/2019	8:19
11/12/2019	9:47
11/13/2019	8:10
11/11/2019	10:24
11/13/2019	9:27
11/11/2019	7:59
11/12/2019	0:00
11/13/2019	7:52
11/11/2019	9:07
11/12/2019	9:51
11/13/2019	7:07
11/12/2019	9:39
11/13/2019	6:12
11/11/2019	9:54
11/12/2019	8:18
11/12/2019	9:30
11/13/2019	9:33
11/11/2019	9:27
11/12/2019	9:57
11/13/2019	9:38
11/11/2019	8:12
11/12/2019	8:45

[sunny_talwar]

What exactly are you hoping to get?

[capriconuser]

i want to get total number of hours worked by week  , month and year @sunny_talwar 

[sunny_talwar]

Just do Sum(Working_Hours) against Week or Month dimension.... will that not work?

[capriconuser]

but how i get each week against each month and year ? this is the problem

[sunny_talwar]

What do you mean? Do you not have a week or month field in your dashboard?

[capriconuser]

i have only date field.. and from that i want to extract moth, year and week field @sunny_talwar 

[sunny_talwar]

Create a master calendar in the script using your date field and you should be good.

Creating A Master Calendar 

[capriconuser]

i already created master calendar.. 

this is what i get

if there is 4 weeks in month then this should be 1,2,3 and 4 for 1 month and if 2nd month start then again 1,2,3,4 must be wirtten .. but here 1,2,3,4,5,6,7 no stop counting is what i get.. and i want to get like this 

1,2,3,4 then again 1,2,3,4 

[sunny_talwar]

Try something like this?

Month Week ( 1 to 4 or 5 weeks)