[General Question] A field which displays the difference between original estimate vs actual time spent?

[Will]

One of our users is requesting to see that (see title) for

• each issue
• total for all issues in an epic

I've seen in your wiki that a global reflexive transition, combined with a removal of the relevant fields from Edit screens can sort of force users to update the values via a transition and thus update a parent task with calculated values from sub-taks (or similarly regular issues to their associated epic) but I'm not sure how well this would work for logging work. The work log depends on permission to log work, and it has it's own entry in the "More Actions >" menu that would allow users to circumvent both editing and a transition to enter time.

Have you come accross a request like this before? Is there some way JWT can help?

Hope this makes sense.

Thanks, W

[Fidel Castro Armario]

Hi @w_b,

First of all, I inform you that we have a new support site. Please, use it for your future questions and support requests.

The best way to implement your request is to use a "Calculated Number Field". This field will always show the updated value.

You should create a "Calculated Number Field" called "Original Estimate - Time Spent" with the following configurations:

1) For Epic Issues, assuming that you don't want to consider sub-tasks: Formula is:

(sum(fieldValue({00068}, issuesUnderEpic())) - sum(fieldValue({00025}, issuesUnderEpic()))) * {MINUTE}

2) For Epic Issues, assuming that you want to consider sub-tasks: Formula is:

(sum(fieldValue({00068}, issuesUnderEpic() UNION subtasks(issuesUnderEpic() UNION epic()))) - sum(fieldValue({00025}, issuesUnderEpic() UNION subtasks(issuesUnderEpic() UNION epic())))) * {MINUTE}

3) For Non-Epic Issues:

Formula is:

({00068} - {00025}) * {MINUTE}

where {00068} is field code for Original estimate (minutes), and {00025} is field code for Total time spent (minutes).

[Will]

Thanks Fidel, I'll try out the above and I will use the other site going forward.

__

Will

[Fidel Castro Armario]

I close this issue. Please, reopen it if you need to.