Project

General

Profile

Actions

Feature #24277

open

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

Added by Marius BĂLTEANU about 8 years ago. Updated 27 days ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues planning
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
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)

Files

remaining_time_in_time_log.png (72.3 KB) remaining_time_in_time_log.png Marius BĂLTEANU, 2016-11-07 01:17
remaining_time_field.png (124 KB) remaining_time_field.png Marius BĂLTEANU, 2016-11-07 01:17
02_add_remaining_time_to_log_time_15945.patch (14.9 KB) 02_add_remaining_time_to_log_time_15945.patch Marius BĂLTEANU, 2016-11-07 01:22
01_add_remaining_hours_field_15945.patch (43.6 KB) 01_add_remaining_hours_field_15945.patch Marius BĂLTEANU, 2016-11-07 01:22
04_add_remaining_time_to_version.patch (3.62 KB) 04_add_remaining_time_to_version.patch Marius BĂLTEANU, 2016-11-12 19:53
03_calculate_done_ratio_using_time.patch (4.35 KB) 03_calculate_done_ratio_using_time.patch Marius BĂLTEANU, 2016-11-12 19:53
02_add_remaining_time_to_log_time_3.4.1.patch (14.6 KB) 02_add_remaining_time_to_log_time_3.4.1.patch Marius BĂLTEANU, 2017-07-10 19:50
03_calculate_done_ratio_using_time_3.4.1.patch (4.43 KB) 03_calculate_done_ratio_using_time_3.4.1.patch Marius BĂLTEANU, 2017-07-10 19:50
01_add_remaining_hours_field_3.4.1.patch (59.1 KB) 01_add_remaining_hours_field_3.4.1.patch Marius BĂLTEANU, 2017-07-10 19:50
04_add_remaining_time_to_version_3.4.1.patch (3.95 KB) 04_add_remaining_time_to_version_3.4.1.patch Marius BĂLTEANU, 2017-07-10 19:50
01_add_remaining_hours_field_5.1.2.patch (35.2 KB) 01_add_remaining_hours_field_5.1.2.patch Radek Pesina, 2024-05-01 03:47
02_add_remaining_time_to_log_time_5.1.2.patch (14.4 KB) 02_add_remaining_time_to_log_time_5.1.2.patch Radek Pesina, 2024-05-01 03:47
03_calculate_done_ratio_using_time_5.1.2.patch (4.23 KB) 03_calculate_done_ratio_using_time_5.1.2.patch Radek Pesina, 2024-05-01 03:47
04_add_remaining_time_to_version_5.1.2.patch (3.73 KB) 04_add_remaining_time_to_version_5.1.2.patch Radek Pesina, 2024-05-01 03:47

Related issues

Related to Redmine - Feature #22326: New 'Remaining Time' field -- NOT related to the % doneNew

Actions
Related to Redmine - Feature #12762: Add option to calculate done ratio with the data from time trackingNew

Actions
Related to Redmine - Patch #1671: Show a breakdown of estimated/spent/remaining time for a versionNewMischa The Evil2008-07-21

Actions
Related to Redmine - Patch #13400: Calculate %done based on estimated and logged timeNew

Actions
Related to Redmine - Feature #5285: Introduce "Remaining time" column on "Issues list" pageClosed2010-04-09

Actions
Related to Redmine - Feature #37862: Estimated time remaining issue query columnClosedMarius BĂLTEANU

Actions
Actions #1

Updated by Marius BĂLTEANU about 8 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"
Actions #2

Updated by Marius BĂLTEANU about 8 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).

Actions #3

Updated by Mischa The Evil about 8 years ago

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

Updated by Mischa The Evil about 8 years ago

  • Description updated (diff)
Actions #5

Updated by Toshi MARUYAMA almost 8 years ago

  • Tracker changed from Patch to Feature
Actions #6

Updated by Chris Russo over 7 years ago

+5!

Actions #7

Updated by Kosta H over 7 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.

Actions #8

Updated by Marius BĂLTEANU over 7 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.

Actions #9

Updated by Marius BĂLTEANU over 7 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.

Actions #10

Updated by Kosta H over 7 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.

Actions #11

Updated by Sudeep Halappa about 7 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.

Actions #12

Updated by Marius BĂLTEANU almost 7 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).

Actions #13

Updated by Anders Thomsen almost 7 years ago

+1

Actions #14

Updated by Marius BĂLTEANU almost 7 years ago

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

Updated by Marius BĂLTEANU over 6 years ago

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

Updated by Marius BĂLTEANU over 6 years ago

  • Description updated (diff)
Actions #17

Updated by Go MAEDA over 6 years ago

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

Updated by Go MAEDA over 5 years ago

  • Target version set to Candidate for next major release
Actions #19

Updated by Anders Thomsen almost 5 years ago

Marius, are you still determined to have this feature added? I'm evaluating if we should should apply the patch to our own instance but will avoid if we have to maintain it for all future versions.

If so, do you plan to provide a patch for 4.1?

Actions #20

Updated by Marius BĂLTEANU almost 5 years ago

Anders Thomsen wrote:

Marius, are you still determined to have this feature added? I'm evaluating if we should should apply the patch to our own instance but will avoid if we have to maintain it for all future versions.

Yes, I still think that it's a good improvement for Redmine, but the decision is at Jean-Philippe.

If so, do you plan to provide a patch for 4.1?

4.1 for sure, but I cannot say about other future versions.

Actions #21

Updated by Bertrand Michas almost 4 years ago

This feature looks nice. We want to be able to say how much work it remains to close a specific version of our software. I hope this will be included in a future Redmine release. Thank you.

Actions #22

Updated by Mischa The Evil over 3 years ago

  • Related to Feature #5285: Introduce "Remaining time" column on "Issues list" page added
Actions #23

Updated by Timo Hamoen almost 3 years ago

Marius BALTEANU wrote:

Anders Thomsen wrote:

Marius, are you still determined to have this feature added? I'm evaluating if we should should apply the patch to our own instance but will avoid if we have to maintain it for all future versions.

Yes, I still think that it's a good improvement for Redmine, but the decision is at Jean-Philippe.

If so, do you plan to provide a patch for 4.1?

4.1 for sure, but I cannot say about other future versions.

Is this feauture ever going to added to 4.2?
Or is there a 4.2 compatible version of the patch?
This is the only thing which is holding us back updating to 4.2 at the moment.

Actions #24

Updated by pasquale [:dedalus] over 2 years ago

+1

Actions #25

Updated by Cathy Barwick over 2 years ago

Is there any update on this ?

We need a way to know both the full time (Estimated Time) - which is best current estimate, and is used in conjunction with % done om the Agile plugin for charts (burndown)

And the remaining time, for planning

(and somehow we also need to keep the original estimate as a "baseline" - we have this as a custom field currently)

Actions #26

Updated by Go MAEDA about 2 years ago

  • Related to Feature #37862: Estimated time remaining issue query column added
Actions #27

Updated by Radek Pesina 7 months ago

Hi,

This is a feature that would be very handy to exist in Redmine! I've had a go at updating the patchsets to the latest version of Redmine (v5.1.2) - they appear to work on my local instance of redmine.

Actions #28

Updated by Marius BĂLTEANU 7 months ago

  • Target version changed from Candidate for next major release to 6.0.0

Thanks Rakek for updating the patches. For now, I've committed #37862 in order to build on top of it this feature.

I'm thinking to make the behaviour for Estimated Remaining Time configurable from Administration with at least two options:
  1. Calculated based on Estimated Time and Done Ratio (#37862)
  2. Use the Remaining Estimated Time field (this issue). If this option is enabled, then we show the field in the issue and time entry pages.

What do you think?

Actions #29

Updated by Zinedine BOUARICHE 5 months ago

Radek Pesina wrote in #note-27:

Hi,

This is a feature that would be very handy to exist in Redmine! I've had a go at updating the patchsets to the latest version of Redmine (v5.1.2) - they appear to work on my local instance of redmine.

Hello Radek,
i'd like to know, i don't know if you have a little amount of time to update this for 5.1.3? it could be really great! i couldn't install the 5.1.2 with bitnami as they give only the last update on their site... i really need this functionnality and as i said could be really great if you could lend me some help!
Thanks in advance!
Cordially.

Actions #30

Updated by Marius BĂLTEANU 27 days ago

  • Target version changed from 6.0.0 to 6.1.0
Actions

Also available in: Atom PDF