I want to show time between creation of a ticket and done, ideally by priority level.

Question

Not sure there is a solution out of the box for Jira with this one:

"I want to show time between creation of a ticket and done, ideally by priority level"

Any idea of what Automation rule or JQL or Gadget that can give me this result. This is for Jira Cloud -premium edition.

Strictly no API route or Add-on route either, I want this result from Jira out of the box or something closer.

Thanks in advance.

Bill Sheboy · Answer

Hi @Master9 Master9

Yes, and...to what John suggests:

Rather than using a scheduled trigger rule, you could trigger on issue transitioned to your "done" status to calculate the time difference and store the value for reporting.  This would handle issues as they complete.

If you wanted to have this value for older issues, the scheduled trigger rule would help update those.  Please note that automation rules are limited to up to 100 issues for processing, so the rule may need multiple executions to "catch up" on the data, and then you can disable it.

Kind regards,
Bill

John Funk · Answer

Hi @Master9 Master9

You will need to create a custom field of number type to store the value.

Then you can create an automation rule that is a Scheduled trigger type that runs once a day or however often you wish.

In that rule, you will have an action for Edit issue. There,  you select the custom number field.

For that field, you will include a formula to do a diff between the created and resolved fields.

See this post for syntax: https://community.atlassian.com/t5/Jira-Software-questions/Calculate-2-Date-difference-in-Hours/qaq-p/2092103