Jira Structure - trying to create a custom formula to calculate % blocked

[Anna Comer]

Hi!

I am trying to use the custom formula capability in my structure to calculate a % of user stories that have an impediment attached. i.e. if under 1 epic all 6 user stories are flagged for an impediment that epic would show 100% blocked. 

I have been playing with the column for hours now but can't seem to get it to return any values. 

[Stepan Kholodov _Tempo_]

Hello @Anna Comer 

If both the Epic and all its Stories are present in the structure, and Stories are placed as the direct sub-issues of the Epic, you can use a formula like this (the format of the column can be changed to Percentage):

if issuetype = "epic" and sum#children{if flagged: 1}>0: sum#children{if flagged: 1}/sum#children{if issuetype: 1}

I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)