Link the calculated fields to time tracking (Original Estimate and Remaining Estimate)

[Bharath Kumar]

This issue has link to both previous issues,Issue #381 and Issue #369

Now coming to the issue, in the previous issues I have mentioned that we are calculating a few fields and summing them up to get the "Component Total" In the subtasks.

Now the the fields that are getting summed up are the estimated number of hours that are required to complete that task, so now the "Component Total" is nothing but the number of hours that are required to complete that component task.

Now in the current instance we just had a custom number field (Component Total which is for subtask and Sizing total for the Story) created and that number field will summed up and shown in the respective field. We would like to have both the total fields to be shown in the Original Estimate field and once the work starts the remaining estimate field should be enabled.

All of this explanation looks a little complex, please let me know if you want me to share the screen and show up whats going on.

[Fidel Castro Armario]

Original estimate stores a value in time units, while Sizing Total and Component Total stores a number of Story points.

Which is the equivalence of your Story points to time units?

[Bharath Kumar]

But how can we link both the fields I mean the total fields and Original Estimate.

Is there a possibility that we can see the total in the estimated field in both subtask and story

[Fidel Castro Armario]

You can select "Original estimate (minutes)" as target field in post-function "Mathematical and date-time expression calculator". We can use a formula to transform the value stored in fields Sizing Total and Component Total to transform the number of story points into a number of minutes.

You can insert the post-function in a transition of the workflow of the sizing story and the subtask workflow in order to set Original estimate (minutes) in those issue types.

[Bharath Kumar]

So what is the formula to transform the number of story points into a number of minutes.

[Fidel Castro Armario]

You have to give the equivalence Story Points - Hours that you want to apply., the I will be able to give you the formula to use.

[Bharath Kumar]

We are planning to do 1 Story point as - 4 Hours, so 2 SP is 1 working day

[Fidel Castro Armario]

You should use "Mathematical and date-time expression calculator" post-function with the following configuration:

• Target field: Original estimate (minutes)
• Formula:

{aaaaa} * 4 * 60

replacing aaaaa with the field code of Sizing Total or Component Total custom fields, depending on the workflow where you are inserting the post-function.

Default JIRA configuration assumes that 1 work-day corresponds to 8 work-hours. If you haven't done modifications it should work as you expect.

Please, try it, and let me know if it works as you expect.

[Bharath Kumar]

What if we wish to have 1SP as 1HR in our Jira instance.

But is it possible to change the default value of 1 SP = 4 HRS to 1SP = 1 HR in Jira, if that is possible we would want to do that and in that case please help me with the new formula

[Bharath Kumar]

Never mind Fidel I figured that out and I was able to fix that, I could figure the formula out as well thanks for the help.

We can now close the issue, you want me to close or will you close the issue.

[Fidel Castro Armario]

This time I close the issue, but please, do it yourself next time, once you consider the issue resolved.

[Marta Lopez Reyes]

Is there any solution without using post functions? I just want "original estimate" field being automaticaly updated based in a formula similiar to yours "story points..., percentt of dedications...etc

I need to have it always updated when some of those fields are edited. Do you understant-me? Is there any feature from 2016?

[Fidel Castro Armario]

Hi @mlopezreye,

You can use a "Calculated Number Field" available in recent versions of JWT. You can configure a formula identical to the one used in "Mathematical and date-time expression calculator" for doing math and time calculations.

Please, create a new issue with the details of your calculation, and I will help you to implement it.

Regards.

[Marta Lopez Reyes]

@fcarmario Thanks! I actually use that "calculated number field" for costum fields but I need it to calculate not a custom field, I need to calculate the "Original estimate" field in order to use the "resources" functionality from BigPicture.

Thanks

[Fidel Castro Armario]

Hi @mlopezreye,

If you want to update Original estimate field, you have to use "Mathematical and date-time expression calculator" post-function. It will only be updated when a transition is executed.

Sorry, that's the only possibility at this moment.