Update Percent Complete on Epics to include stories on child epics

[Scott Stahr]

Current the field Percent complete by count on the Epic form is automatically using the following formula:

( Number of completed stories on the epic / Total number of stories on the epic ) * 100

Is there a way to also include child epics in the calculation?  For example, if a parent epic has two stories associated to it and a child epic associated to it with two stories of it's own, if one of the stories completes the Percent complete by count would be 25%? 

[Kieran Anson]

Hi Scott,

This could be done however after looking at the ScrumRollup script include that manages this, my main question is how recursive would you want this extension to be in terms of the overall percentage.

Should the percentage only take into account direct child epics or whats if those child epics also have additional child epics? Sort of a spanning tree of epics which can occur...but possibly might not be done in your environment.

As the evaluation is completed on the closure of a story rather than an update to the parent epic, currently what occurs in the script is a lookup to the parent record and then find any stories where their parent is the same epic. This then allows for a calculation of complete_count and percent_complete_by_count fields.

You would require a change to take into account stories on the parent epic and then look at epics where the parent epic is that epic and then look into those stories (starting to get into murky waters here in terms of calc time and possible recursive code.....).

TL;DR - Should the count field take into account direct child epics and their stories. Or also include child epics, child epics and so on.

[Scott Stahr]

Thanks for responding Kieran!  After consulting with our resident Agile master, we've decided to disable child epics for the organization so we no longer need this.

[Kieran Anson · Accepted solution]

Ah that's an even easier a solution (and a wise one in my opinion!). If you could mark your question as answered (should be able to select your own reply as the answer) it'll close down the question.