I'm trying to figure out if it is possible to create an analysis that shows the time needed to complete all of the stories for multiple epics based on the current sprint cadence. The objective is to show additional resources are required. I hope this is clear. My leadership is requesting me for this analysis.
Welcome to the Community!
I understand you'd like to know how much time each Epic consumes in your company and you use worklogs to track time spent.
You might be interested in giving our Clockwork Free or Pro a go. With this app in either version, you will be able to use Timesheet view to neatly display a breakdown of how much time was spent on what. The breakdown options and levels are customizable, so each user can shape the timesheet to their needs.
It looks like shown in the screenshot below and it's very intuitive and easy to use. Currently, we do not support filtering by Sprint, but with the Project filter and date range selector, you should be able to easily filter out the issues you need.
If you have any questions about it, feel free to reach out to our support team. We'll be happy to present the capabilities of our tools, which reach far beyond what is described above.
Cheers!
Welcome to the community, @Jack Preijers.
Another option would be our Jira cloud app Quick Filters for Jira Dashboards.
Our app enables you to generate statistics for time tracking and all other Jira number fields directly on your Jira dashboard. With the Quick Controller gadget, you can easily filter the dashboard gadgets dynamically, such as by sprint.
Please note that you might have to enable the feature "smart dropdowns" in order to filter by sprint.
You can check out Quick Filters for Jira Dashboard without installing it on your demo dashboards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
welcome to the community!
Do I understand correctly that you want to sum-up the total time spent on your epics, from the epics' various stories?
There may be reports provided by Jira, as described here. I'm not a great expert in this area, so perhaps someone else can jump in here - but I personally can't remember a report giving you these numbers.
Alternatively, there's a large number of reporting-focused apps on the Atlassian Marketplace. Some of these tools are very powerful, and I would assume that there's more than one solution that would be able to solve your problem. I can only speak for the app that my team is working on, JXL for Jira; in JXL, I believe this would be reasonably easy to solve.
JXL is a full-fledged spreadsheet/table view 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 (configurable) issue hierarchies, issue grouping, sum-ups, or conditional formatting. With these, you can build reports very easily, like for example this:
This is showing the "original estimates", would it would work the same way with "time spent" (and any other field, really). You could also group your issue by their last sprint, etc. etc., and configure different sum-up methods.
As said above, there may be different tools that can solve this for you. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.
Any questions just let me know,
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.