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; } } }

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

julia_l5merf

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

Accepted answers

All comments

Trudy P 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.

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.

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

Dmitry Astapkovich _Colined_

Hi @julia ,

You may want to check our app Pivot Report for your estimation vs logged time reporting:

In this demo report (you can check it yourself) I've added three progress indicators: Work Ratio, Time Budget and Accuracy. All of them are based on original estimates and spent time. Hope that covers your needs

We can arrange a quick call to over the demo and/or your reporting needs.

Gökçe Karaduman-The Starware

Hi @julia

You can easily do this using Jira's built-in "Filter Result" dashboard gadget. You can create a JQL filter for the sprint and add required columns to gadget configuration. Please check the attached example.

Michał Kowalewski_SolDevelo

Hi @julia

If you are open to third party apps, then I can recommend Worklogs - Time Tracking and Time Reports, app developed by the company I represents.

The app will allow you to easily view a given sprint, tasks from that sprint and the original estimate value.

Untitled design (14).png

What's more, you can view your reports on the Jira dashboard for each sprint.

Untitled design (15).png

The app has many more features, including the ability to export data, filter time logs via JQL, permissions, etc.

If you use Jira's native time logging feature then just install the app and you are ready to generate reports.

If you have any questions regarding the app feel free to contact us here, or book a demo session here.

Kind regards,
Michał
SolDevelo Team

Josh

You can list sprint issues with Original Estimate and Time Spent. That is all time ever logged on those issues, not only hours logged during the sprint.

Native Jira does not give “hours logged in this sprint” as a column. If you need that cut, it is worklog date vs sprint dates, not the Time Spent field.

Disclosure: I work on Aneto Hours Reports and Resource planner. Pick the week that matches the sprint.

Listing: https://marketplace.atlassian.com/apps/1219348/aneto-hours-reports-and-resource-planner

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-data-center

report

data-center

time-report

original-estimate

time-spent

retrospective