Actual Time Spent vs Estimated Effort comparison report | Targetprocess - Visual management software

Actual Time Spent vs Estimated Effort comparison report

A visual representation of work items (User stories, Bugs and Tasks) organized by the percentage by which the actual Time spent on a work item exceeds the Effort assigned to it.

Lets create a new Visual Report for this purpose (Create > Report > Blank). We need to select Bugs, Tasks and User Stories as 'Entities' for our report, specify the Projects and Teams needed in the 'Projects and Teams' selector and add the following filter to the 'Filter' area:
?TimeSpent > Effort and Effort > 0

Creating new Visual Report with filter on TimeSpent and Effort

After the report is created, lets drag and drop the 'Name' parameter to X-axis, 'Assigned User' to Y-axis and remove 'Count of records' calculation from axes at all.

Setting the axes of the report

Now we need to create a new calculation by hitting 'Add field or formula' button ('Formula' tab). Lets give a name to our formula, ex. 'Overtime ratio', and populate the formula area with the following one:

TimeSpent / Effort

Adding new formula

After saving the newly created formula, lets drag and drop it to the 'Size' panel. Now you are able to easily recognize the work items with the bigger number of the overtime ratio:

Adding 'Overtime ratio' to the 'Size' panel

After you set everything up, you may want to tune your chart a bit to show, lets say, only the work items with overtime ratio greater than 1.3. In order to do that, please click on 'Chart data' button > 'Add filter' and select the values you need from the drop-down lists as in the following example:

Filtering the data of the report

You may also want to drag 'Type' parameter to 'Color' panel to have your data grouped and colored by Entity Types (Bugs, Tasks and User Stories):

Adding 'Type' to 'Color'

After you hit the 'Finish setup' button, you are welcome to drill into details of your report to find and check the work items which required much more time to be implemented than it was estimated initially.

Drilling into details


Still have a question?

We're here to help! Just contact our friendly support team

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Start your free trial

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo