Progress Formula JIRA Structure

[christine_pfaffenrot]

Hi,

it there a way, how I can calculate and display the progress for an Initiative based on a formula that refers to epics? 

The tricky things is as following: I have an Initiative (parent), conceptional epic(child) and below the epic either an implementational epic or an initiative. The implementational epic/initiative is linked as realized by.  I would like to calculate the progress of all implementational epic/initiative and display that in the initiative. Is there a way how I can do that?

Thanks in advance! 

Kind regards,

Christine

[Stepan Kholodov _Tempo_]

Hello @christine_pfaffenrot 

If your goal is to calculate the progress of the top-level Initiative using only the values of Implementational epics from the 3rd level of the hierarchy - i.e., ignoring values of direct Conceptional epics - then you can do it with a formula like this:

if issuetype = "initiative": sum{if issuetype = "implementational epic": value}/sum{if issuetype = "implementational epic": 1}

where value is the name of the field that the progress os based on. The names of issue types should be stated as they are displayed in Jira.

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)