nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

David Niro

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

All comments

David Niro

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

structure

expr

formula