Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,370,153
Community Members
 
Community Events
168
Community Groups

Calculation of Percentage in Jira Structure

Edited

Hi,

I need to understand the math behind the calculation in Jira Structure at parent level.

On the sample below I need to know formula used to determine 66% at parent ticket level. I included screenshots on how the Progress by Percentage was configured.

Hope to hear from your team soon!

The percentage with purple icon is the parent ticket

The percentage with the green icon are the child tickets

Sample1.PNGSample3.PNG

Sample2.PNG

1 answer

1 accepted

2 votes
Answer accepted

Hello @Tristen John Bagain ,

David from ALM Works here.  Welcome to the Community!!

I see from your screenshots that your progress is weighted by story points.  In this case, the total progress is going to be the sum of individual issue Progress (P) multiplied by individual issue Story Points (SP) and then divided by the sum of the story points.

∑(SP*P)/∑SP

Please let me know if this helps!

Best,
David

Thanks, David for the feedback. Can you share how it is computed manually? I tried the formula you gave but I can't get the 66% completion progress on the original screenshot I shared

Sample4.PNG

Like Dave Rosenlund _Tempo_ likes this

Hello @Tristen John Bagain ,

You are very welcome!  I see two things that are happening here.

The first is the 20% should be 30%, making the SUM of your Progress 950%.

The second is how undefined values are handled.  If an issue has an undefined value (blank) in the field you are considering for weight, the progress calculation will assume a value for it.  

The assumed value is the average of the values from the issues that do have one defined.  In this case the average is 4.69.  If you want the weight of the issue to be 0, you will need to enter 0.

Screen Shot 2022-09-19 at 12.10.05 PM.png

Please let me know if this helps!

Best,
David

Like Dave Rosenlund _Tempo_ likes this

Thanks, David. Is the above algorithm true for all other fields that will used for "Weight" (other than "All Sub-Issues are Equal")? 

Like Dave Rosenlund _Tempo_ likes this

Hello @Tristen John Bagain ,

Yes, it is true for all other fields used for weight.  It is a weighted average calculation which is:

∑(WF*V)/∑WF

Where WF is your your Weight Factor (here story points) and V is your Value (here progress).  The only things that would change would be what you define as your Weight Factor or Value, latter of which can be Resolution Only or Custom Percent Field in addition to Status.

Best,
David

Like # people like this

One last thing @David Niro _ALM Works_ is there like repository page where we can see all algorithm for % Progress calculation based on what Value and Weight Factor was used?

Sorry I said in my previous comment that i'm good :P

Hello @Tristen John Bagain ,

No apology is necessary!

We have documentation related to Progress Column that can be found here.

Best,
David

Suggest an answer

Log in or Sign up to answer