Feature #24277

Introducing Remaining Time field as method to track the remaining time to complete an issue

Added by Marius BALTEANU almost 3 years ago. Updated 5 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues planning
Target version:Candidate for next major release
Resolution:

Description

Currently, Redmine offers the possibility to estimate an issue and track the time spent on that issue using the log time module.

Regarding the progress made on an issue, the only possibility is to use the "Done ratio" field, but there are some major disadvantages from our point of view:
1. update action requires multiple clicks
2. is not so accurate because if you calculate the remaining time using the formula "done ratio * estimated time" it means that the remaining time can't be greater than estimated time.
Having the following scenario:
  • Issue with estimated time set to 4h
  • During the development you discover that more hours (6h for example) are required

In order to correctly register the remaining time, you need to change the estimation from 4h to 6h and let the done ratio to 0%. Otherwise, the remaining time will be still 4h.

3. there is no relation between the log time and the done ratio field

Attached there are 2 patches:

1. 01_add_remaining_hours_field_15945.patch:
  • adds a new core field named "Remaining time" which behave almost like the Estimated time field
  • automatically set the remaining time equal with estimated time when the remaining time is null and estimated time > 0.
  • automatically set the remaining time to 0h when closing the issue.

2. update_issue_remaining_time.patch: the user can decide in the log time form to update or not the issue remaining hours. There are 3 options available:
- [default] adjust automatically: issue remaining time will be decreased with the logged number of hours.
- set to x hours
- do no update remaining time.

In this way, the issue remaining time can be tracked easily.

Also, we have in plan the following improvements:
- a new option for "Done Ratio" field to be calculated using the estimated time and remaining time
- better time tracking details in the version page.

There are multiple issues related to this feature:
  • DoneRatio_issues_overview - Section "Requests (and patch) for adding 3rd option "Use the logged and estimated time"
  • #22326 (implemented by the first patch)

remaining_time_in_time_log.png (72.3 KB) Marius BALTEANU, 2016-11-07 01:17

remaining_time_field.png (124 KB) Marius BALTEANU, 2016-11-07 01:17

02_add_remaining_time_to_log_time_15945.patch Magnifier (14.9 KB) Marius BALTEANU, 2016-11-07 01:22

01_add_remaining_hours_field_15945.patch Magnifier (43.6 KB) Marius BALTEANU, 2016-11-07 01:22

04_add_remaining_time_to_version.patch Magnifier (3.62 KB) Marius BALTEANU, 2016-11-12 19:53

03_calculate_done_ratio_using_time.patch Magnifier (4.35 KB) Marius BALTEANU, 2016-11-12 19:53

02_add_remaining_time_to_log_time_3.4.1.patch Magnifier (14.6 KB) Marius BALTEANU, 2017-07-10 19:50

03_calculate_done_ratio_using_time_3.4.1.patch Magnifier (4.43 KB) Marius BALTEANU, 2017-07-10 19:50

01_add_remaining_hours_field_3.4.1.patch Magnifier (59.1 KB) Marius BALTEANU, 2017-07-10 19:50

04_add_remaining_time_to_version_3.4.1.patch Magnifier (3.95 KB) Marius BALTEANU, 2017-07-10 19:50


Related issues

Related to Redmine - Feature #22326: New 'Remaining Time' field -- NOT related to the % done New
Related to Redmine - Feature #12762: Add option to calculate done ratio with the data from tim... New
Related to Redmine - Patch #1671: Show a breakdown of estimated/spent/remaining time for a ... New 2008-07-21
Related to Redmine - Patch #13400: Calculate %done based on estimated and logged time New

History

#1 Updated by Marius BALTEANU almost 3 years ago

Please fix the following typos in the description:
  • "can decide it the log time form what to updated or not the issue" -> "can decide in the log time form to update or not the issue"
  • "issue remaining time with be decreased" -> "issue remaining time will be decreased"

#2 Updated by Marius BALTEANU almost 3 years ago

Added last two patches on this topic.

03_calculate_done_ratio_using_time.patch

Option to calculate the done ratio based on estimated and remaining hours. If the setting "calculated from subtasks" is set, the done ratio is calculated based on total estimated and total remaining hours.

04_add_remaining_time_to_version.patch

Add remaining time under the estimated time in version page. This info is very useful especially when you use the versions as sprints and you need to move unfinished issues from a version to another version.

For example:

Version 1 at the beginning:
Issue Estimated Remaining Status
1 10h 10h New
2 15h 15h New
3 15h 15h New
4 14h 14h New

Version estimated time: 54h.
Version remaining time: 54h.

At the end of the version, only Issue 1 and Issue 2 are finalized and Issue 3 and Issue 4 moved in version 2.

Version 1 at the final:
Issue Estimated Remaining Status
1 10h 0h Closed
2 15h 0h Closed
3 15h 4h In Progress
4 14h 4h In Progress

Version estimated time: 54h.
Version remaining time: 8h.

Version 2 at the beginning:
Issue Estimated Remaining Status
3 15h 4h In Progress
4 14h 4h In Progress
5 10h 10h New
6 10h 10h New

Version estimated time: 49h (which is the sum of initial estimations).
Version remaining time: 28h (which is the real required time to finish the version).

#3 Updated by Mischa The Evil almost 3 years ago

  • Related to Feature #22326: New 'Remaining Time' field -- NOT related to the % done added

#4 Updated by Mischa The Evil almost 3 years ago

  • Description updated (diff)

#5 Updated by Toshi MARUYAMA almost 3 years ago

  • Tracker changed from Patch to Feature

#6 Updated by Chris Russo over 2 years ago

+5!

#7 Updated by Kosta H over 2 years ago

Marius, these patches look great! Unfortunately they don't apply cleanly to Redmine 3.3.2, 3.3.1 or to `master`. If you have a git branch and publish it, I could help with rebasing. Would love to see this make it into core.

#8 Updated by Marius BALTEANU over 2 years ago

Kosta H wrote:

Marius, these patches look great! Unfortunately they don't apply cleanly to Redmine 3.3.2, 3.3.1 or to `master`. If you have a git branch and publish it, I could help with rebasing. Would love to see this make it into core.

I'll upload a new version of the patches after the release of Redmine 3.4.0.

#9 Updated by Marius BALTEANU over 2 years ago

I've updated the patch series to apply cleanly to the latest Redmine version (3.4.1) and current trunk (r16811).

For us (Zitec) it is a very important feature, so any feedback regarding the implementation is welcome. I'll be very happy to discuss the changes required to implement this feature in the core.

#10 Updated by Kosta H about 2 years ago

Thanks so much Marius! Could the maintainers please weigh in on whether this might make it into 3.4.x or 3.5.x? I'd very much like to use these patches on my organization's Redmine instance but am hesitant to without knowing if they'll make it into the upstream branch.

#11 Updated by Sudeep Halappa almost 2 years ago

This is exactly the feature I am looking for.

Apologies for the naive question. Will this feature work for Redmine 3.3.3.stable? That is the version we are currently using.

#12 Updated by Marius BALTEANU almost 2 years ago

Sudeep Halappa wrote:

This is exactly the feature I am looking for.

Apologies for the naive question. Will this feature work for Redmine 3.3.3.stable? That is the version we are currently using.

I didn't tests the patches against 3.3.3.stable, but you could try to apply the first version (uploaded by me in 2016).

#13 Updated by Anders Thomsen almost 2 years ago

+1

#14 Updated by Marius BALTEANU almost 2 years ago

  • Related to Feature #12762: Add option to calculate done ratio with the data from time tracking added

#15 Updated by Marius BALTEANU over 1 year ago

  • Related to Patch #1671: Show a breakdown of estimated/spent/remaining time for a version added

#16 Updated by Marius BALTEANU over 1 year ago

  • Description updated (diff)

#17 Updated by Go MAEDA over 1 year ago

  • Related to Patch #13400: Calculate %done based on estimated and logged time added

#18 Updated by Go MAEDA 5 months ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF