how to sumup hours by gropu by assigne in jira for sprint
5 answers
Hi @M Purushotham Reddy , welcome to the community!
As already mentioned here, there is no out-of-the-box solution for this in Jira.
To add to the Atlassian Marketplace suggestions, you may want to have a look at the app that my team and I are working on: JXL for Jira .
JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a long list of further features, including work item grouping based any work item fields, as well as sum-ups.
With these, you can build a view like e.g. this in just a couple of clicks:
The above gif just shows one possibility, time based fields can also be summed up, of course. You can also create your own custom structure, that would allow you to group by sprints and within a sprint by assignees.
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 configurable issue hierarchies, to conditional formatting, or inline bulk editing via copy/paste.
Any questions just let me know,
Best,
Paul
Welcome to the community !!
If you are open to try out a mktplace solution, you can have a look at our app,
The app allows you to view your Issue Hierarchy in a tree view and as a dashboard gadget as well. The app sums up the time spent at each parent level. You can also group it by assignee and filter the issues only for a particular sprint. Do give it a try.
Disclaimer : I am one of the app team member
Hello @M Purushotham Reddy
Based on your need for a single report showing total logged hours per assignee within a sprint, I’d recommend trying my team's app Worklogs - Time Tracking, Time Reports, Timesheets.
With Worklogs – Time Tracking, Time Reports, Timesheets, you’ll be able to generate a report of time logged in a given sprint per user in seconds, group it by issuetype, save it with a dynamic date range, share it with your team, and even present it visually as a pie or bar chart. Please see a possible report view for your use case below:
Please note that the above screenshots are just an example of a report that may work for your use case. Worklogs' reports are fully customizable and adjustable to your needs, with multilevel filtering, grouping, and categorizing options.
Some of our app's other key features include:
✅ Instant, flexible reporting – Group and categorize data seamlessly with powerful aggregation.
🔍 Advanced filtering – Filter by date range, projects, users, groups, JQL filters, or custom fields.
📊 Custom dashboards – Add personalized gadgets to visualize your data.
🌍 Smart settings – Adjust time zones, units, or holidays directly in the app.
📤 Easy sharing – Export and share reports externally with stakeholders.
🔐 Access control – Manage permissions and restrict access to predefined users or groups.
You can learn more and try it out with a 30-day free trial on our Marketplace page — or explore the full feature set in our documentation.
Best,
Agata - SolDevelo Team
Hi @M Purushotham Reddy ,
My name is Sergio, and I'm a member of the support team in Decadis. I would like to suggest you an approach using our app SumUp for Jira.
We offer several gadgets options in our app, which you can check in this page from our documentation.
For your requirement, I would suggest using our gadget Two Dimensional Filter Statistics, which allows you to group by two different fields, for your current case, issue type and assignee.
When you configure this gadget:
- For the JQL, you can filter by project and sprint.
- In the field which will you desire to sum, just select "Σ Time Spent", which is the sume of the logged time for those issue types and assignees.
- For "Group X" and "Group Y" column values, just select assignee and issue type.
With this configuration, you will see the different logged time in your issue types by each user and also the total amount of time that has been logged by each user and by each issue type:
We hope this approach looks useful for you. If you have any doubts related our app, please feel free to share it here and I will gladly assist you.
Also, we have a customer support portal where you can create any request with any concerts you might have regarding our apps!
Best regards,
Sergio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.