Currently, there is no easy way to answer this scenario without creating a report and exporting to excel to do additional calculations:
- The user has completed 100 tasks for the quarter/month/year. How many (or what percent) of those task were completed ahead of the task due date, same day as the task due date, and/or past the task due date?
We would like a report to give us metrics on how well users are performing against the task/workflow due date. Task Duration only calculates the time difference between when the user was assigned the task and when s/he completed the task. We would like a field that also calculates the variance between when a user completed the task against the task/workflow due date. Currently there is no field that give us this option, and the workflow fields are not accessible to create a formula to calculate.