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

Change RAG Indicator by comparing the target end date of the milestone and initiative

Wendy_p5waty

Hello all,

Thank you very much in advance for helping me with this question.

I'm trying to set an automation up for JIRA dashboard and here is what I would like to achieve:

Trigger: changes to Target End Date will trigger this automation

Setup: the link issue type between milestones and initiatives are "is contributing to" and "contributes". For each milestone, there will be multiple initiatives.

Condition: compare the Target End Date of these multiple initiatives within a milestone and only the one whose target end date is furthest into the future will be used to compare with the Target End Date of the milestone. If initiative is 15 days later than milestone, then the RAG indicator will turn red.

What I have written for the condition and it doesn't work: [initiative.target end.max].diff(intiative.parent.target end).Days

Thank you!

Accepted answers

All comments

Bill Sheboy

Hi @Wendy -- Welcome to the Atlassian Community!

For a question like this, please post images of your complete rule, showing any relevant details of actions, and of the audit log details showing the rule execution. Those will provide context for the community to offer suggestions. Thanks!

Until we see those...

You are trying to find the maximum of a field, Target End, for several issues. I suggest using the Lookup Issues action with JQL to gather up the relevant issues. Once you have them the max operator can be used on the results, and that can then be used in your subsequent math operation for the rule.

Please look here for some information on those actions and functions:

Kind regards,
Bill

Wendy_p5waty

Hello Bill,

Thank you very much for your answer. I have tried the method mentioned by the above links but still failed.

The Target end date of DBTS-59 is Dec 21 2023 and the target end of the milestone is Dec 13 2023 but DBTS-59 RAG indicator still turned red. Could you please kindly help? Thank you very much!

Automation log .png Automation Rule .png Automation Rule 2.png Automation Rule 1.png

Bill Sheboy

Wendy, would you please post an image of your entire rule showing all of the steps? That will provide some context to help explain what you are observing. Thanks!

Wendy_p5waty

Hello Bill,

The above screenshot is the whole set up of the rule. I have tried to debug by setting up another rule and edit the comment to see if i am able to get any data from it. but it turns out that i cannot extract any data from {{issue.parent.customfield_17804}}. That's why the above calculation of days does not work.

Automation debug.png

From this link i understand that parent can only work when the issue is a sub-task. However, i have set the initiative as a subtask for the milestone (please find the picture below). Is it because the way i set the subtask is wrong? Could you please advise? Thank you!

Link: Jira smart values - issues | Automation for Jira Data Center and Server 9.0 | Atlassian Documentation

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud