You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Background: One of the performance efficiency metrics for a team is “Spill-over rate”
Definition: The average number of story points that have spilled over to future sprints in all the competed sprints in a given time range.
Formula: Total number of spilled over story points in a given time range / total number of completed sprints in a given time range
Requirement: In order to calculate the above metric, can I think of approaching this through an Automation by introducing a custom field (SpillOverStart)?
Solution Approach:
Trigger: Issue field update (sprint)
Condition: If Issue.statusCategory = "In Progress" and {{issue.sprint.split(“,”).size}} > 1
Action: SpillOverStart = {{issue.sprint.split(“,”).get(1).startDate}} (start date of the 2nd sprint (index 1) in the array)
JQL to be used by the Scrum Master for computing this metric: (export the output to an csv and add up the total story points and divide it by the number of completed sprints)
project = <project_name> and issuetype not in (epic,sub-task) and SpillOverStart is not empty and (SpillOverStart >= "2023-01-01" and SpillOverStart <= "2023-03-31")
I am stuck with the above Action as it is NOT working out. Any leads on where I am going wrong or another way of achieving this will be highly appreciated.
Finally it worked. Two learnings:
1. Issue.statusCategory does not work as a JQL. So, I had to replace it with status not in (Done,"To Do")
2. split(“,”) is not working or may not be required. So, my Advanced compare condition looks like: {{issue.sprint.size}} > 1 and Action looks like: SpillOverStart = {{issue.sprint.get(1).startDate}}
Hello @Deloitte Mohajit
Welcome to the Atlassian community.
In what way is the automation not working?
What does the Audit Log contain when the rule executes?
Have you used the Log action to print out the smart values that you are using to see if they contain the values you expect?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, Trudy for reaching out.
Automation audit log says "no action performed"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That indicates that the rule was triggered, but the issue that triggered it did not meet the Conditions. Review the triggering issue, which is noted in the Audit Log, and the Conditions in your rule. If it doesn't meet the Conditions then the rule is working correctly, as per the instructions you gave it.
You can use the Log Action to print values into the audit log, like the smart values tou specified in tour conditions, to see the values the rule is getting from rhem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.