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. 

[Hannes Obweger - JXL for Jira · Accepted solution]

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

[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

[Hannes Obweger - JXL for Jira]

Fantastic - please reach out anytime for questions or feedback. Just as a quick heads-up: We plan to make some improvements to the "Export to Excel" feature, to better account for groupings in our export. I'd suggest that you give JXL a try, and if the current export becomes an issue, we'll see if we can accelerate this stream of work.

[Mariana_Pryshliak_Saasjet]

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.

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

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.

[Chasovskikh Kirill]

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

[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. 


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.

[Rahul_RVS_Support]

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.

[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?