Hi everyone, I need your help. I’m working on a development about absenteeism, and I stuck with the actual data that I have.
At this day, my data is like this :
id_abs
B_date_abs
T_date_abs
12354
01/01/2014
20/04/2014
1454
23/02/2014
25/03/2014
8454
30/03/2014
01/04/2014
The goal is to analyse the % of absenteeism regarding the month selected or the year. So, for the first line, we've got 31 days of absenteeism in January, and 20 in february.
If I want to see the amount of days in february, it'll be 20 days (1st row) + 6 days (2nd row). What will be the best way to allocate those days for each months ?
This is really useful, thanks. Any chance you can shed some light on how to do this with hour detail?
I managed to work out the proportion in an expression but I can only use it when analysing by employee and month EmpHours_in_this_month = ( Total_EmpHours / Total_EmpDays) / EmpDays_in_this_month
I would like to do this on the script, can anyone help?
