Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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 

1 answer

1 accepted

1 vote
Answer accepted

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,


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

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.

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. 

Like Bill Sheboy likes this

Hi @Phlip Borgnes 

Another variation for automation is to leverage the Sprint field is a list, so when an issue finally moves to "done", the count of the number of sprints it took is:


Best regards,


Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...

106 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you