nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to make a report about how many sprints it's taking for each ticket so far?

Saifeldin Ibrahim

I want to know if there's a way to show the number completed sprints for each ticket instead of checking each ticket individually, for reporting purposes

Accepted answers

Bill Sheboy

Hi @Saifeldin Ibrahim -- Welcome to the Atlassian Community!

I do not believe that there is a built-in way to do this, such as with JQL. You could try the following to help solve this. These solutions vary depending upon how often you need this information and if you want to spend more money on products.

Export the data you are interested in, and parse the sprint field in a spreadsheet to count the values using a formula (count non-empty columns starting with the word "Sprint")
Check the marketplace for add-on features for JQL that might allow you to count values in the sprint field
Build your own solution using the built-in automation rules:
- Add a custom field, such as SprintCount
- Add an automation rule, triggered on Sprint Completion, and increment the SprintCount

Best regards,

Bill

All comments

Bill Sheboy

Hi @Saifeldin Ibrahim -- Welcome to the Atlassian Community!

Export the data you are interested in, and parse the sprint field in a spreadsheet to count the values using a formula (count non-empty columns starting with the word "Sprint")
Check the marketplace for add-on features for JQL that might allow you to count values in the sprint field
Build your own solution using the built-in automation rules:
- Add a custom field, such as SprintCount
- Add an automation rule, triggered on Sprint Completion, and increment the SprintCount

Best regards,

Bill

Saifeldin Ibrahim

Hi @Bill Sheboy , i had to do it the classic way and export all the tickets (like your first point) but using the built-in automation rules is a really good idea. will try that

thanks for the advice

Bill Sheboy

Thanks for the update. If this approach works for you, please consider posting back here to share your findings and mark this question as answered. That will help others find solutions faster in the future.

Phlip Borgnes

Hi @Bill Sheboy
I was looking for an answer to this question as well and will be creating a post function for the number of sprints an issue was in.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software