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

Hours and tasks in sprint report

Chasovskikh Kirill

Hello, friends!

Does anyone have an idea, how to generate excel report with all tasks in sprint, that contains fields:

- summary, status, assignee, original estimate

- time tracked in sprint in each task by user

- all time tracked in each task

Report should include tasks with tracked time and without tracked time.

Now i generate this report manualy - from filter results and from worklog.

Accepted answers

Hannes Obweger - JXL for Jira

Hi @Chasovskikh Kirill

JXL for Jira is another app that could be useful to you. It's a full-fledged spreadsheet/table view for your issues that allows grouping and summing up your issues based on any issue fields, including sprints and assignees.

This is how this could look in action:

You can perform different kinds of sum-ups, including including, of course, a straightforward "sum" of all work logs. If you need further processing outside of Jira, you can export your sheet to Excel or CSV with one click.

(It's worth noting that JXL can do much more than that - from inline editing and issue creation, to quick sorting and filtering, to support for issue hierarchies. More info at https://jxl.app. Disclaimer: I work on JXL )

Hope this helps,

Hannes

All comments

Mariana_Pryshliak_Saasjet_qysy8m

Hello @Chasovskikh Kirill

You can try a third-party add-on - Time in Status for Jira Cloud, that generates status time reports. For your case, Time in Status and Assignee time reports becomes helpful.

A Time in Status report shows how long an issue has been spent in each status.

tis report.png

An Assignee time report displays how long a particular Assignee has been working on each issue.

assignee report.png

Choose the date ranges you need and generate reports, which you can download to Excel.

If you need more complicated reports, you can use a Pivot table function.

This add-on is developed by my SaaSJet team, so if you have any questions, I'm here to help you.

Rahul_RVS

Hi @Chasovskikh Kirill

If you are fine with a marketplace app, you can try out our add-on to get this data

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features.

Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. You can filter based on worklogs time period as well.

Worklogs Report.PNG

Chasovskikh Kirill

we are using Worklogs, but how to add in report tasks from sprint, if they don't have logged work in this sprint?

Chasovskikh Kirill

Thank you! but we need info about worklogs and other tasks from sprint, not assignee and status time

Hannes Obweger - JXL for Jira

Hi @Chasovskikh Kirill

This is how this could look in action:

Hannes

Chasovskikh Kirill

Is there any way to show in columns field Original Estimate ?

Hannes Obweger - JXL for Jira

Hi @Chasovskikh Kirill - yes! You can view, edit, and sum-up any Jira field, including the Original Estimate field.

Chasovskikh Kirill

thank you! we will try it

Ewa Grabowska-Ptak_SolDevelo_

Hi !

I represent Worklogs Time Tracking and Reports by SolDevelo. Although our tool does not meet all of your requirements, I believe it would still be worth checking out for you or anybody else interested in time reports by sprint.

Our app generates reports to Jira native function - Time Logs, it would be perfect to sum up the time spent on tasks during the sprint. However, it won’t show the tasks which weren’t worked on during the sprint (with 0 time logged during the sprint).

What makes Worklogs great is that you can choose to filter out the data by specific Sprint. So, in one click you can both select specific issues and the correct date range.

sprint select.gif
You can chose to create a report based on any Jira issue fields, including the custom ones. So, for example you can check the time spent on specific client, priority or epic.

The report can be exported to excel, shared with a link or added to a dashboard with a gadget.

Hope it helps! Please feel free to check it out in a free trial or in our Interactive Demo here.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

time-tracking

sprint

report