Jira Structure - Formula columns

[Rafael Tognolo]

Hello,

I'm trying to create different formula columns.

1 - Formula column for the number of issues that are closed within an Epic/Task. 

2 - Formula column for the percentage of issues that are closed within an Epic/Task.

Can you assist with these formulas, please?

Thanks

[David Niro · Accepted solution]

Hello @Rafael Tognolo ,

David from ALM Works here.

I will be happy to assist with creating a formula to match these goals.

Could you share the current structure hierarchy, please?  We will need to review this in order to create a formula.

I look forward to your response.

Best,
David

[Rafael Tognolo]

Hi @David Niro 

The hierarchy is:

Epics
     Tasks
          Sub-tasks

Thanks

[David Niro]

Hello @Rafael Tognolo ,

Thank you.

Apologies, I should have asked this previously, but would the goal be to show ALL of the "Done" issues, or just those directly under the current level?

For example if you have this hierarchy:

Epic 1 
  Task 1 (Done) 
    Sub-Task 1 (Done)
    Sub-Task 2
  Task 2
  Task 3
    Sub-Task 3 (Done)

Should the Epic level show 3 issues done, or just 1?  Additionally, should the Epic & Tasks consider their own status for the % Done calculation?  

To illustrate why I ask, if we consider bullet 1, we could approach it in three different ways, using either a #children, #leaves, or #subtree modifier:

WITH done_issues =
COUNT#leaves{IF(status="Done";1)}
:

IF (issuetype = "Task" OR issuetype = "Epic")AND done_issues>0:
done_issues

#children would give us 1 since it's looking at direct descendants (the Tasks)
#leaves would give us 2 since it is looking at the items without children (Sub-Task 1,2,3 and Task 2)
#subtree would give us 3 since it is looking at everything, including the Epic

Also, my response time has been a bit slow this week, for which I apologize.  Please feel free to contact our support team via email support@almworks.com or through our customer portal support.almworks.com.

Best Regards,
David

[Rafael Tognolo]

Thanks @David Niro 
We managed to create the formula after your last post. Really appreciate that, it's been very useful.

Best regards,
Rafael

[David Niro]

you're very welcome!