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; } } }

Structure Formular based on custom field

Jeanne Howe_56oel8

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?

Accepted answers

David Niro

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_56oel8

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

All comments

David Niro

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_56oel8

Fantastic!

Thank you David.

David Niro

you're very welcome!

Jeanne Howe_56oel8

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

This product never stops being amazing. Thank you!

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

structure

addon-com.almworks.jira.structure

jira-software-server

data-center

expr

formula