Create automation for the RAG status to a task to alert us when tasks are behind schedule
2 answers
1 accepted
PRECONDITION: Enabled the template automation to sum all of the child StoryPoints in the parent Epic. Meaning that the trigger issue has a StoryPoint value.
SCOPE:
For testing purposes, the trigger is manual and ONLY on Epics (though I'll set this to a schedule when it goes live),
DATA VALIDATION:
Status != Done
Start Date is not empty
Due date is not empty
VARIABLES:
we create a variable (Note : customfield_10015 is my 'start date')
Variable name = PercentageOfProjectLeft
Smart value = {{#=}} {{now.diff(issue.dueDate).days}} / {{issue.customfield_10015.diff(issue.dueDate).days}} * 100 {{/}}
Then a lookup of the INCOMPLETE children of the trigger epic
parent = {{key}} and statuscategory != doneNext, another variable to sum the story points of all the INCOMPLETE children and work out the percent we have yet to complete
Variable name = RemainingStoryPointsPercentage
Smart value = {{#=}} {{lookupIssues.Story Points.sum}} / {{issue.Story Points}} * 100 {{/}}
LOGIC:
*NOTE* our options are 'Less than' and 'greater than', so we have to ensure we capture the 'is equal to' (less than 21 starts at 20, etc)
Followed by an if branch
if PercentageOfProjectLeft < 21 AND RemainingStoryPointsPercentage > 39, then
Red
else PercentageOfProjectLeft < 41 AND RemainingStoryPointsPercentage > 59,
OR
PercentageOfProjectLeft < 61 AND RemainingStoryPointsPercentage > 79, then
Amber
else
Green
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.