Hello everyone,
I would like to sum the original estimate field of a parent (epic, task, story) from subtasks. My automation works for weeks, days and hours but not for minutes :(
And for exemple, if I have 2 tickets with 35m and 25m it will not sum and add 1h.
Do you have a solution for that ?
Thank you !
Hi @MaximeDu74
Have you confirmed the values in the lookup results match what you expect? For example, you could write all of the values to the audit log to check them:
original estimate values: {{#lookupIssues}}{{key}}:{{Original Estimate}}; {{/}}
Update: please see the end of this thread for a better solution. I'm striking-out this one.
Next, the way your rule is written, it uses the human-readable smart value for Original Estimate (e.g., 35m) and lets the expression automatically convert to seconds. Perhaps try using the specific smart value for the seconds value:
{{lookupIssues.timetracking.originalEstimateSeconds.sum.divide(3600)}}
Kind regards,
Bill
Hello @Bill Sheboy
Thank you for your reply.
The value in the lookup results match what I expect. If I have 3 tickets with : 1d 2h; 1h; 0m, I will have in the parent 1d 3h.
I tried to modify the "edit issue" with what you told me but it didn't work (see the screenshot).
I checked in the log with the code you gave me. For ticket GOUV-42 I have 5400, which is correct and equals 1h 30m. But the 30m is not added to the parent :(
Thank you for helping me,
Maxime
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Update: please see the end of this thread for a better solution. I'm striking-out this one.
How about this: remove the divide by 3600 and add the units of measure of seconds:
"{{lookupIssues.timetracking.originalEstimateSeconds.sum}}s"
I hypothesize there is some truncation happening and this would confirm / resolve that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
After experimenting a bit I confirmed three things:
And so this JSON will correctly set the value from the lookup values:
{
"fields": {
"timetracking": {
"originalEstimate" : "{{lookupIssues.timetracking.originalEstimateSeconds.sum.divide(60)}}"
}
}
}
I will go back and strikethrough my earlier, incorrect suggestions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Bill Sheboy ,
This solution doesn't work. 2h (child) => 3w (parent). I tried to modify "divide(60)" with "divide(3600)" but the minutes are not record.
I don't know how to manage this problem...
Thank you,
Maxime
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
These cases work for me with Jira Cloud automation rules. If your rule matches what I have described, I am unclear what else to check.
At this point, please work with your Jira Site Admin to submit a ticket to Atlassian Support to take a look at your rule: https://support.atlassian.com/contact/#/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @MaximeDu74
I trust that you'll be able to resolve this using Jira Automation!
Just as food for thought: If you are open to solutions from the Atlassian Marketplace and want to save some Automation budget, there's also a number of apps available that can help with this. Depending on your exact use case, some app will be a better fit than others, but it might be worth some research.
As an example, estimate sum-ups are easily possible using the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
With these, you can build a view like e.g. this in just a couple of clicks:
As you can see above, the summed up original estimates would update live as you enter your values.
This is really just one of a virtually endless number of possible views and reports: You can also view, group, and sum-up any other issue fields, configure different sum-up styles (like min, max, or average), etc. etc. All this just works - there's no scripting or automation whatsoever required.
Any questions just let me know,
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Hannes Obweger - JXL for Jira ,
Thank you for your reply but I would like a free solution, it's why I want to use Jira Automation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.