Hi Team,
I am using Jira Cloud and need automation rule for below requirement:
Automation to display total elapsed time spend by user in team or group on Jira Issues in each project
Hi @Sattar Baig
You can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.
Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Time in Assignee report. For further details, please check Status Time Reports How to Videos.
If you are looking for a completely free solution, you can try the limited version Status Time Free.
Hope it helps.
Hello @Sattar Baig 👋
As an alternative, you can try Time in Status for Jira Cloud (developed by my team). The primary purpose is to help teams gather valuable data about the lifecycle of your issues in Jira. Add-on allows you to measure and visualize the time spent in each status, such as "Open," "In Progress," "In Review," and "Closed," and provide 7 types of reports to help you identify areas for improvement.
This add-on generates 7 types of time tracking report, such as
Assignee Time report displays the total elapsed time spent by the user in the team on Jira Issues in the project.
Also, you can extract a report as XLSX or CSV files for further analyzing Excel or Google Spreadsheets easily.
Add-on has a 30-day free trial version and free up to 10 users.
Please, let me know if you have any questions
Hope it helps 😌
Valeriia
Hi @Sattar Baig
you might consider using time-tracking apps that in most cases have a customizable report of tracked time on issues.
I can recommend our Clockwork Automated Time Tracking & Timesheets Pro app, which offers you the possibility to review timesheets and create reports that can be configured in various ways using break-down and filtering options. In your case, you can simply choose what project you would like to include in the timesheet and choose the users/teams which you would like to see.
We've recently added an option to create Teams and use it to filter the data in the timesheet.
This way you can quickly see how much time was spent on a specific project, and team.
Please find below the sample of how the timesheet looks like:
If you have any questions you can contact us via our help center.
Cheers!
Gracjan
Hi @Sattar Baig
Did I understand correctly that you would like to have an insight such as this?
Based on this summary, you would like to have the collective hours spent for a period of time in a project, by each team.
In our team we are currently working to find a solution to this exact problem. Can you please confirm that I understood you correctly?
Thanks!
Elena
Hi @Sattar Baig
I'd like to show you an app that our team developed for creating reports for Jira time logs → Worklogs - Time Tracking and Reports.
The app can display a report that includes total time logged by your users for different projects. What's more you don't have to display each user separately, but you can display it for your groups & teams as you described in your post.
Creating such a report with our app is very easy and user-friendly, please take a look:
You can filter the report in many other ways as needed. There are many additional features, but it's best if you find out for yourself. You can do it right now even before you decide to install it, because we have an interactive demo available for everyone here.
You get a 30-day trial period from the time of installation to see if the application meets your requirements.
We are also happy to answer any questions about our application. Feel free to contact us by going to this link.
Kind regards,
Michał
SolDevelo Team
Hello @Sattar Baig
Doing this with Automation is hard because you'll need to create separate custom fields and automation rules for all the times you want to measure. It will be expensive to build and maintain. In fact, all the data needed for this calculation is already available in each issue's history but Jira doesn't give them as ready-to-go-reports. You'll need a marketplace app to get ready-to-go reports on these.
Our team at OBSS built Time in Status exactly for this. It is available for Jira Server, Cloud, and Data Center.
Time in Status mainly allows you to see how much time each issue spent on each status, each assignee, or each group.
You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc.
For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend.
The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects for Jira Cloud.
Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.
https://marketplace.atlassian.com/apps/1211756/
EmreT
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Jira Administrator
Configure Jira Software, Jira Core, or Jira Service Management, including global settings, permissions, and schemes.
Managing Jira Projects Cloud
Learn to create and configure company-managed projects in Jira Software and partner effectively with Jira Admins.
Learning Path
Become an effective Jira Software Project Admin
This learning path is designed for team leaders who configure Jira Software projects to match a team's processes.