Report for sprints - time tracking original vs logged or original vs final

[julia]

I have run sprints, i have 2 questions:
1. in my completed sprint it shows the following information. I need to also see the logged time for each of these? How do I update this?

Key	Summary	Issue Type	Priority	Status	Original Time Estimate (1d 3h)

2. I need to create a dashboard or a report that shows logged time vs original estimate for either selected issues or issues during a sprint.
at this point I have no idea how to generate any retrospective or report to show if estimates are close to the logged time

we have a data center...not the cloud

[Trudy Claspill]

Hello @julia 

1. The report that you see when you navigate to Reports / Sprint Report is not customizable. You will not be able to add columns to that display.

You could create an alternate view of the data using a Saved filter, and adding the columns to the List View of the filter results.

2. Jira natively does not support reporting time logged during a time period. You could get a report that shows the Original Estimate and all time logged against each issue for issues in the sprint, but not just the time logged against the issues during the sprint. Would that suffice?

You could do that by creating and saving a filter that selects the issues of interest. In a Dashboard you could add the Filter Results gadget to show that list of issues. You can select the fields you want to display in that gadget, and you could include the Original Estimate and Time Spent fields.

[Hannes Obweger - JXL for Jira]

Hi @julia

if you're open to solutions from the Atlassian Marketplace, I think you might like the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for issue grouping by any issue field and sum-ups.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc. As every JXL sheet is powered by a JQL query or saved filter, you have full control over which issues should be included in your sheet. Of course, you can always refine the list via JXL's rich column filtering capabilities.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to conditional formatting, and inline bulk editing via copy/paste.

Any questions just let me know,

Best,

Hannes

[Danut M _StonikByte_]

Hi @julia,

I'm afraid that this is not possible with the Jira report. 

A solution would be to search on Atlassian Marketplace for a plugin that is capable to display such report.

If you decide to try a plugin, our Great Gadgets app can be a good solution. It offers a Team Velocity gadget that can calculate by Time Remaining & Time Spent and has an option Ignore the time logged before the start of the sprint.  

The gadget displays the past (closed) sprints, but it can be configured to also display the current (incomplete) sprint(s). If you check its option for displaying the data table, the gadget will display a Data tab with the issues from the sprint along with the time spent during that sprint (on the Completed column): 

The gadget displays also a velocity chart base don the time logged during sprint along with initial and final commitment:

Danut.