Task Management Software for Team Collaboration
 
HomeDownloadSupportPurchase
 
Installation GuideStartUp GuideOnline Help

Average Overdue Time of Tasks

Average Overdue Time of Tasks
   
Home  » Products  » VIP Task Manager Pro  » Tutorials  » Customization Guide  » 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
  • Average Overdue Time of Tasks

    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

    Average Overdue Time of Tasks

    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.

    Average Overdue Time of 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.

    Average Overdue Time of Tasks

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

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

    Average Overdue Time of Tasks

    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”
  • Average Overdue Time of Tasks

  • 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”
  • Average Overdue Time of Tasks

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

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

    Average Overdue Time of Tasks

                           

                            Overdue time of tasks per project on Task Tree


Play demo Play Demo

TryTry It FREE
Overview VIP Task Manager

» VIP Task Manager Pro
   VIP Task Manager Std
   Testimonials
   Turnkey Solution

Available: Workdays, Monday - Friday
8 am - 8 pm GMT for Europe/Asia
1 am - 1 pm PST for America




Login:
Password:
Register
Forgot your password?
Login As:
Login As
You can log in if you are registered at one of these services:

ProductsSolutionsDownloadSupportPurchaseContactsForumVideoMy Account
Copyright © 2004 - 2017 Task Management Software
 
          
 
Site Map