How do I run a report for resource hours spent

[Lisa Bishop]

How do I run a report that will give me how many hours each resource spent on an issue. Similar to time tracking but with more detail.

[Nataliya Vasyliv_Reliex_]

Hi @Lisa Bishop 

If you still considering a solution I would suggest ActivityTimeline. It's resource planning plugin with a lot of reports. You can check resource utilization, calculate workload, worklog, availability with various of details about the issue and project.

Hope it helps! If you have any additional requirements please feel free to ask me. We can demo session for you if needed. 
Nataliya,  ActivityTimeline Team.

[Karolina Wons_SaaSJet]

Hello @Lisa Bishop 

You can try a Time in Status for Jira Cloud add-on developed by my SaaSJet team. 

It generates 7 types of time reports, including Time in Status and Assignee time reports. Time in Status report shows how long an issue has been spent in each status. 

Assignee time report shows how long each assignee has been working on each issue.

Is that what you need? 

Hope, you find it helpful.

Regards, Karolina.

[Bloompeak Support]

Hi @Lisa Bishop

Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need assignee time calculation.

For this exact need we developed Status Time Reports app. By default, it provides reports on how much time passed in each status. But it can also provide assignee time. You can also export the report as CSV and open it in Excel.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, assignee 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. It has various other reports like status entry dates, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try without installing the app. Hope it helps.

[Ewa Grabowska-Ptak_SolDevelo_]

Hi @Lisa Bishop , 

I would like to invite you to try out our app - Worklogs Time Tracking and Reports . It's a tool that allows you to create custom reports based on Jira Time Logs and Jira issue fields.

For example, you can check how much time was spent on Jira issues by the issue Assignee, issue type and specific issues:



You can also check, how much time each user logged to specific issues and story points:



As you can see there are lots of possibilities of what you can check with those reports. You can view the whole organisation or filter by specific projects or JQL filters. Reports can be exported and shared by a link. 

I hope you check it out! Please also do not hesitate to contact me here, I'll be happy to help with any question or set up a meeting with an app showcase.  

[Rahul_RVS_Support]

Hi @Lisa Bishop 

Welcome to the community !!

For a readymade solution, to get the time spent data, you can try out our plugin

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features.

Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. You can filter based on worklogs time period as well.

Along with this there are multiple other features like Time in Status, Links Hierarchy, Epic Hierarchy etc which the app provides.

[Howard Nedd]

Hi,

You could try the workload pie chart.  It will show all the time spent by users in the project for example.

Hope that that helps.

Regards,
Howard

[Lisa Bishop]

Howard, thanks for this, but I need more detail. I need it broken out by assignee by task. Project level is too high. Any ideas?

[Sandstorm Media GmbH]

Hi Lisa,

you could also give Exply a try. It can give you as much details as you need :) Feel to let me know if you need assistance :)

Fabian from Exply