Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Not getting the actual time spent for certain issues in a particular sprint. Why?

I have been using Jira to keep record of the time spent in particular issue in a specific sprint. image.png

After selecting the attributes and the sprint (say Sprint 2), I export my Jira report in excel form(csv) but I get to see that the time spent in particular issues have been cumulative for some issues(say, issues which were  already in Sprint 1 and continued in Sprint 2).

But I need only the report for Sprint 2 and the actual time spent on issues, and not the cumulative time spent on some issues. 


1 answer

1 accepted

3 votes
Answer accepted

JIRA does not natively provide sophisticated filtering/reporting for Work Logs. It will provide you with all the Work Log information for the selected issues.

You will need to consider a third party app if you want an automated solution. And I am not sure if there actually is an app that would provide you with what you want. Or, you might be able to use the REST API to extract the information you want.

In our JIRA Cloud instance we use

Worklogs - Time tracking and reports 

I think with that you could produce a dashboard that would give you the data you wanted, and it does include an export feature.

@Trudy Claspill  Thanks a lot !

I have one last query regarding Worklogs - Time tracking and reports. In the dashboard the filters are configured with respect to the dates.

Instead of selecting the dates , should I be able to filter with respect to sprints(as sprints already hold the information when it was started and ended)  ?  

This app does not extend the filtering capabilities of JIRA. You create a filter to get the issues that you want using the native JIRA filtering capabilities. The app gives you the ability to then pick out the worklogs from those issues and group the data by, for instance the issue it was logged against, the user who logged it, and/or the day it was logged.

Sprint is a selectable field for Grouping and Categorizing the worklog data in the dashboard gadget from this app, but I don't know how that actually impacts the data displayed. We use Kanban do I don't have worklog data for issues in Sprints against which I could experiment.

You can get the app for a free trial period though. You might want to install it and see what you can do with it.

Like Anirban Dey likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

295 views 9 7
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