i need to bulk update estimates and remaining estimates.

Question

when they close tickets and forget to zero out remaining estimates the calculation of remaining estimates on an epic level gets distorted.

i would like to set 0 as remaining estimate for all closed items. i can do an automation for the ones to be closed in the future, but we have 1000 of closed items with estimates

anything I can do? bulk does have only story points estimates.

Hannes Obweger - JXL for Jira · Answer

Hi @Andras Harman

welcome to the community!

I trust that you'll be able to resolve this using Jira Automation based on Karan's great answer.

Just for future reference: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 long list of advanced features, including the ability to bulk-edit and bulk-clear your issues in just a few clicks, like so:

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Karan Sachdev · Answer

Hey Andras,

Welcome to the Community!

You may create an automation rule with the scheduled trigger and run it once only to fetch the closed issues and update their remaining estimate to 0.

Trigger: Scheduled trigger

Use JQL in the trigger: project = "<project key>" and statuscategory = Done and remainingEstimate != 0

Action: Edit Issue: Set the Remaining Estimate field = 0

You may disable this rule once the it is executed for all the closed issues.

For the future rules, you can write a similar rule with the issue transitioned trigger so it runs when the issue is closed.