Total hours spent by user in a Sprint

[Swapnil Patil]

Hello Team,

Is there a option available in Jira report or gadget where I can create a dash board so that I can see total hours spent by each user in a sprint.

I tried to search using existing gadget but not able to find a relevant one.

Can you please help.

Thanks,

SP

[Hannes Obweger - JXL for Jira]

Hi @Swapnil Patil

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your work items (issues) that allows viewing, inline-editing, sorting, and filtering by all your work item fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a long list of advanced features, including support for work item grouping by any work item field(s), 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. 

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

Any questions just let me know,

Best,

Hannes

[Rahul_RVS]

Hi @Swapnil Patil 

Welcome to the community !!

If you are open to try out alternate apps for logging hours and detailed time tracking reports, I can suggest the one we have developed 

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily add the worklog authors and time tracking reports as a dashboard gadget. Main features of the app -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Time sheet screen. With Calendar view and Board view

Disclaimer : I am part of the dev team

[Karan Sachdev]

Hey @Swapnil Patil

Welcome to Atlassian Community!

We don't have built-in reports or dashboard gadgets to meet this requirement. You may explore Marketplace apps that offer extended reporting functionalities and dashboard gadgets.

Thanks!

[Alexey Pavlenko _App Developer_]

Hi @Swapnil Patil ,

You can use for that the app I developed - Multi-team Metrics & Retrospectives.

To accomplish it, you can create custom metrics using jql per engineer. Please check the screenshot below (on the same screenshot you can see the metric dynamics between the current and previous sprints as well):

Also, you can check the summary of metrics:

Best regards,
Alexey

[Fatma Uzundemir from The Starware]

Hi @Swapnil Patil 👋🏻,

Welcome to Atlassian community! 🍀

We understand that Jira’s native options may not fully meet your needs, and we don’t want this to be a limitation for you. If you are open to exploring third-party solutions, I’d like to introduce WorklogPRO - Timesheet for Jira, a powerful and user-friendly application that provides all the features you are looking for.

🌱 With this application, you can create periods based on your sprint dates or any custom time ranges and generate fully customizable reports tailored to your needs. These reports offer a wide range of options, such as grouping by user, team, or project, and incorporating your existing JQL filters. You can also add the fields you want, giving you full control over your report columns.

For example, you can create a JQL filter that includes all issues in the sprint you want to analyze and easily add it to your report. This ensures that all relevant information for that sprint is readily accessible, making your reporting process more efficient and insightful.

 
🌱 These reports are accessible both via dashboard gadgets and the dedicated reports page, and can be exported in CSV, Excel, or PDF formats for easy sharing and analysis. WorklogPro streamlines your reporting process, saves time, and ensures you always have accurate. 

🍀 To learn more, feel free to contact me or explore the application through the Atlassian Marketplace link I’ve provided. 🍀 

---

Disclaimer:I work for the vendor who developed this application.

[Tomasz Korusiewicz_SolDevelo]

Hi @Swapnil Patil 

Welcome to Atlassian Community!

Natively, Jira does not have any reports or dashboard gadgets to count the total hours spent by a user in a sprint.

However, you can make use of the Atlassian Marketplace app that has these options, such as our Worklogs - Time Tracking, Time Reports, Timesheets app, developed in-house by our team at SolDevelo.

With Worklogs, you can easily filter the time spent by specific Jira users on Sprints, Work Items, Projects, and other Jira fields, within a specific date range:

 

Our app also allows you to browse your time tracking reports within the handy dashboard gadget:

 

Moreover, it is worth adding that if the time was previously logged into the issue through Jira, then these logs should already be visible in Worklogs, as it makes use of Jira's native time tracking features.

Feel free to try it out on our marketplace page!

All the best,
Tomasz
SolDevelo Team