Task Management Software for Team Collaboration
 
HomeDownloadSupportPurchase
 
SupportFAQForumHelpdeskCompanyContact Us

How to make report on the tasks completed before/on/after due date

How to make report on the tasks completed before/on/after due date
   
Home  » Support  » Frequently Asked Questions (FAQ)  » How to make report on the tasks completed before/on/after due date

To make report on the tasks completed before/on/after due date, please, do the following:

  1. Go to main menu [Tools -> Custom fields…]
  2. Click on ‘New' button on the toolbar of ‘Edit custom fields' dialog
  3. Enter ‘Task Completion Date' into ‘Title' entry field, select ‘Date' type from ‘Type' drop-down list and click 'Ok'
  4. In the same way create ‘Task Due Date' custom field
  5. Create a new custom field ‘Due Date Deviation' that has ‘String' type and enter following formula into ‘Formula' field:
  6. iif($cf_task_due_date>$cf_task_completion_date, ToString($cf_task_due_date-$cf_task_completion_date) + " day(s) before Due Date", iif($cf_task_completion_date>$cf_task_due_date, ToString($cf_task_completion_date-$cf_task_due_date) + " day(s) after Due Date", iif($cf_task_due_date=$cf_task_completion_date, " meets Due Date", "")))

     

  7. Create a new custom field ‘Completed' that has ‘List' type and enter following formula into ‘Formula' field:
  8. iif($cf_task_due_date>$cf_task_completion_date, 1, iif($cf_task_completion_date>$cf_task_due_date, 3, iif($cf_task_due_date=$cf_task_completion_date, 2, 0)))

  9. Click on ‘Add' button
  10.  

  11. Enter ‘1' into ‘Value' entry field, ‘before the Due Date' into ‘Title' entry field and click ‘Ok'
  12. In the same way add ‘on Due Date' and ‘after the Due Date' titles with ‘2' and ‘3' values correspondingly and click 'Ok' 
  13. Display ‘Completed', ‘Task Due Date', ‘Task Completion Date ' and ‘Due Date Deviation' columns on Task List grid
  14. Set filter by task resource, Task Due Date and Task Completion Date
  15. Group the tasks by ‘Completed' column
  16. Go to ‘Charts' panel, select 'Pie diagram' and click on ‘Print' button on Charts toolbar to print out task percentage tasks completed early/late/on time



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


Skype

My status

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




Feb 1, 2016 TopTenReview: VIP Organizer is one of the best organizer software
TopTenReview has published Organizer Software Review 2016 and our product has been included to the list of the best software programs for personal information management. The author considers VIP Organizer to be a good choice if you are looking for something simple to help you organize your days.

More News


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