Automation to display total elapsed time spend by user in team or group on Jira Issues in project

[Sattar Baig]

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

[Dan -minware-]

Hey @Sattar Baig -

Are you tracking time on your tasks currently?

Our company, minware, is the only 3rd party service on the market that I am aware of able to completely automate your request without the use of any sort of manual time tracking or worklogs. 

We offer a free trial if you want to check it out!

[Mehmet A _Bloompeak_]

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.

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you are looking for a completely free solution, you can try the limited version Status Time Free.

Hope it helps.

[Valeriia_Havrylenko_SaaSJet_AbcSite]

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 

• Time in Status,
• Average Time, etc.  
• Assignee Time,

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 

[Gracjan Wesołowski _HeroCoders_]

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

[ElenaK_NemetschekBG]

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

[Michał Kowalewski_SolDevelo]

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

[Emre Toptancı _OBSS_]

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