Structure Formular based on custom field

[Jeanne Howe]

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?

[David Niro · Accepted solution]

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:
  FORMAT_VALUE(DEV_Value,QA_Value,STAGE_Value)

It can always be modified to include more if needed.

Please let me know if it helps!

Best,
David

[Jeanne Howe]

Fantastic!

Thank you David.

[David Niro]

you're very welcome!

[Jeanne Howe · Accepted solution]

@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?

[David Niro]

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:
  FORMAT_VALUE(DEV_Value,QA_Value,STAGE_Value)

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!

Best,
David

[Jeanne Howe]

This product never stops being amazing. Thank you!