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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Summarize tasks by sprint

Nathan Decker
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 03, 2023

I would like to analyze and report on tasks by sprint. I would ideally export all tasks worked on during a sprint and then analyze in excel.

This becomes difficult because of tasks that span sprints.

If a task spans more than one sprint, multiple "sprint" columns are added to the spreadsheet. If column one and column two are both "sprint", with values "sprint 24" and "sprint 25", it becomes impossible to see how much of a tasks "time spent" was associated with sprint 24 vs sprint 25, because the "time spent" column spans both sprints.

If I could export tasks based "time spent" completed in a sprint with a unique row per sprint, that would be great. In the above example, the same task would have only one column for "sprint" (not two) and two rows for the same task. Sprint 24 would be on one row with a "time spent" value and the same task would be on Sprint 25 row with it's own time spent during its sprint.

Perhaps there is a setting somewhere that summarizes each row discretely by work contained in a sprint, or someone else encountered this and solved it in another way. 


1 answer

1 vote
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 04, 2023

Hi @Nathan Decker ,

Try downloading the report for each sprint separately. This way, you can analyze the data better.

Another tip is to try using Cost Tracker for Jira Cloud.

In the use cases, we have described in detail how you can get informative reports and, for example, analyze the cost of one sprint - 💡Use Case: How to estimate the sprint cost in Jira.

For now, if the cost calculation is irrelevant to you, you can use the Time report feature of the application.

Get a 30-day trial to get to know the addon better.

I hope it will help you solve your problem!

P.S. My team developed the app, and we are active users of the app, so if you have any questions or ideas, don't hesitate to contact us via support.


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events