Overall this is a part of a project utilisation application that shows utilisation at a region, role and worker level and can be reported weekly and monthly
Lets assume we are calculating weekly utilisation for 2 workers and we won't take into account role weighting and assume there are no holidays or any other time off.
Let's assume there are 22 days in the month excluding weekends and both worked full 7.5 hour days.
Target Hours = 22 days * 7.5 hours per day = 165 hours
Worker 1: worked every day in the month; 22 days * 7.5 hours per day = 165 hours
Utilisation: 165 hours worked / 165 target = 100%
Worker 2: worked from the 11th to 24th; 10 days * 7.5 hours per day = 75 hours
Utilisation: 75 hours worked / 165 target = 45.45%
The problem comes arises when the target hours for Worker 2 is calculated as 75 hours because they only have time records from 11th to the 24th but I need their target to be 165 hours.
These are the Variables I have...
vFirstSelectedPeriod = min([Period])
vLastSelectedPeriod = max([Period])
vWorkDaysInPeriod = NetWorkDays($(vFirstSelectedPeriod), $(vLastSelectedPeriod))
Please help. I'm very new to Qlik.
Neil
