Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Structure Formular based on custom field

We are building out a Structure in JIra DC to track Bugs found by Release. Within the Structure we have a Single Select Custom field can "Found in Environment". For each Bug, the submitter selects the environment they were working in when they found the Bug.

We would like to develop a formular that will count the number of Bugs within the release by the environment at the release level

See image below


Is this possible with a column formular?

2 answers

2 accepted

1 vote
Answer accepted

Hello @Jeanne Howe ,

David from ALM Works here.

If it's just the three environments, this formula should do the trick:

WITH FORMAT_VALUE(value1,value2,value3) =
"""DEV = $value1 QA = $value2 STAGE = $value3"""

WITH DEV_Value = COUNT#truthy#children{FoundinEnvironment = "DEV"}:
WITH QA_Value = COUNT#truthy#children{FoundinEnvironment = "QA"}:
WITH STAGE_Value = COUNT#truthy#children{FoundinEnvironment = "STAGE"}:

IF !issuetype:

It can always be modified to include more if needed.

Please let me know if it helps!



Thank you David.

Like # people like this

you're very welcome!

Like Dave Rosenlund _Tempo_ likes this
0 votes
Answer accepted

@Dave Rosenlund _Tempo_ 

Hi Dave,

One more question on this formula. Is it possible to "roll up" each count to the project level? and if not, can the formula be set to only run against the levels below the project?


Hello @Jeanne Howe 

We can definitely do that and based on what I see in the screen capture it may be an easy adjustment!

Are there ever any issues that would be below the bugs in this structure?  Sub-tasks, or some other issue linked to it?

If not, we just need to change #children to #leaves in the formula.

WITH FORMAT_VALUE(value1,value2,value3) =
"""DEV = $value1 QA = $value2 STAGE = $value3"""

WITH DEV_Value = COUNT#truthy#leaves{FoundinEnvironment = "DEV"}:
WITH QA_Value = COUNT#truthy#leaves{FoundinEnvironment = "QA"}:
WITH STAGE_Value = COUNT#truthy#leaves{FoundinEnvironment = "STAGE"}:

IF !issuetype:

If there will be another level of issues in the hierarchy this approach won't work, but while the solution may be a bit more complicated there is still a solution :) 

Please let me know if it helps!


This product never stops being amazing. Thank you!

Like David Niro _ALM Works_ likes this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events