Roll up local value to parent group-by in Jira structure

[marc_olivier]

I have a Jira structure to help us identify those that needs leadership review.

It looks like this:


A bunch of Jira items, grouped by "functional team".
I calculate a custom field, "Needs review," which looks at other fields from each Jira item (see query below) and flags them with a "Needs review" or "No review needed" with some markup (I am using Jira structure on DC).

I want to be able to add a flag at the group-by level to highlight whether any item underneath requires a review, e.g. I would like to show that we need to expand each Functional Area - Functional Team.

I tried the following formula but was unsuccessful.

IF depth == 2: 
   IF AND( 
      OR(
         DAYS_BETWEEN(updated,today())<7, 
         DAYS_BETWEEN(created,today())<7
      ), OR(
         risk_level == "Moderate", 
         risk_level == "High", 
         risk_level == undefined
      ), OR(
         estimated_impact == "1 - Severe", 
         estimated_impact == "2 - High", 
         estimated_impact == "3 - Moderate", 
         estimated_impact = undefined
      ) 
   ): 
      """{panel:borderSytle=solid|borderColor=white|bgColor=#EF4B59} (*y) {color:white}Needs review{color}{panel}""" 
   ELSE: 
      "{panel:borderSytle=solid|borderColor=white|bgColor=#eeffee}No review needed{panel}" 
ELSE: 
   MAX#children{needs_review}

From other help threads, I know it is possible to aggregate values to a parent from children/leaves. Is it possible to do the same to show a value at a group-by-level?

Thank you!

[Stepan Kholodov _Tempo_]

Hello @marc_olivier 

You can use a formula like this:

with needs_review =
IF AND(

      OR(

         DAYS_BETWEEN(updated,today())<7,

         DAYS_BETWEEN(created,today())<7

      ), OR(

         risk_level == "Moderate",

         risk_level == "High",

         risk_level == undefined

      ), OR(

         estimated_impact == "1 - Severe",

         estimated_impact == "2 - High",

         estimated_impact == "3 - Moderate",

         estimated_impact = undefined

      )

   ): "Needs review":

if issuetype and needs_review: """{panel:borderSytle=solid|borderColor=white|bgColor=#EF4B59} (*y) {color:white}Needs review{color}{panel}""" else

if issuetype and !needs_review: "{panel:borderSytle=solid|borderColor=white|bgColor=#eeffee}No review needed{panel}" else

if !issuetype and count#children{IF AND(

      OR(

         DAYS_BETWEEN(updated,today())<7,

         DAYS_BETWEEN(created,today())<7

      ), OR(

         risk_level == "Moderate",

         risk_level == "High",

         risk_level == undefined

      ), OR(

         estimated_impact == "1 - Severe",

         estimated_impact == "2 - High",

         estimated_impact == "3 - Moderate",

         estimated_impact = undefined

      )

   ): "Needs review"}>0: "(flag)"

It will return 'Needs review' for all issues that match the condition, 'No review needed' for all other issues and it'll show the red flag emoji for each group that has at least one issues that needs review in it.

I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)