XPM - Add customisable productivity reports
Productivity Reports
I am using report builder to create a productivity report for my staff. What i would like to show on the report is:
Capcity reducing time + billable time + non-billable time = total time for week
I would then like a productivity percentage calculated as billable time / (billable + non-billable).
I would also like this report to have a YTD actual column and YTD budget column so that on one report I can see how productivity as been for the most recent week but also YTD on the on the report.
This will then tell me how many hours/days a staff member has had off on annual/sick/exam/LWOP etc and also how productive they were for the hours they were actually at work.
I cannot seem to generate this report. If I just use billable plus non-billable their total time equates to less than 38 hours and i don't know if this is because they haven't added all their time or because they've had capacity reducing leave.