Average Overdue Time of Tasks

Average Overdue Time of Tasks

Average overdue time of tasks is a key performance indicator that shows the average past due time (duration) within which the task has been finally completed since its Due Date.  Overdue time is calculated by the following formula:

Due Date – Closure Date

Due Date is the date by which the task should have been completed.

Closure Date is the actual date of task accomplishment.

Depending on your needs this KPI helps to compare how productive the resource was over some period of time.

If you need to count average overdue time of tasks, you need to do the following:

1. Create custom field "Closure Date”:

• Go to: Tools/Custom fields and press "Ins” button
• In "Title” field enter "Closure Date”
• In "Code” field enter "cf_closure_date”
• In "Type” field select "Date” and click "Ok” button



2. Create custom field "Overdue Time”

• Go to: Tools/Custom fields and press "Ins” button
• In "Title” field enter "Overdue Time”
• In "Code” field enter "cf_overdue_time”
• In "Type” field select "Duration”
• In Formula field enter the formula below and click "Ok” button

$due_date - $cf_closure_date



3. If you need to view the average overdue time of tasks per particular project, filter your to-do list by task group with project tasks.



4. Set filter by Status "Complete”. If you also need to view the average overdue time per assigned resource and some time span, set appropriate filter on Task List – Filters panel.



5. Set footer to display the average overdue time of tasks:

• -  right click under column "Overdue Time”
• -  select "Average”



If you need to view the average overdue time of tasks on Task Tree, please follow the steps below:

• On Task Tree select root task group and select "Custom fields options”



• To enable the displaying of average overdue time select custom field "Overdue time”,  do the following:
  •  - select Enable
  • - check "Aggregated (for task group)
  • - select "Average” and the custom field name "Overdue time”



• Select task group for which you need to view the average overdue time, right click and select "Custom fields options”



• Select custom field "Overdue Time” and select the option "Enable by parent”.





                       

                        Overdue time of tasks per project on Task Tree