Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I did... but in that image you have made a selection on week1.... if you don't want your month chart to change it's value based on selection in month... then in your expression ignore selection in week field.... 🙂
What exactly are you hoping to get?
i want to get total number of hours worked by week , month and year @sunny_talwar
Just do Sum(Working_Hours) against Week or Month dimension.... will that not work?
but how i get each week against each month and year ? this is the problem
What do you mean? Do you not have a week or month field in your dashboard?
i have only date field.. and from that i want to extract moth, year and week field @sunny_talwar
Create a master calendar in the script using your date field and you should be good.
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
Try something like this?