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.
![](https://secure.gravatar.com/avatar/ed1aca3b389f8e85ab918b6e7edfba59?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)