Detail report on Time spent

[Mahanth Prudhvi P]

I would like to know if there is a way to have detail report on time spent updated by users.

Scenario: All the users Dev , QA, UI teams will be updating their time spent on tickets.

Let's say a developer has updated time spent 1hr( Coding) and then 10minutes (Unit Testing) ,likewise different time spent updating scenarios for different users. At the end of the sprint a developer might have updated his/her time spent total 160 hrs out of which 5hrs is Unit testing and 20hrs is some ABCD. 

So I would like to differentiate and track how much time spent by individual user in unit testing, coding or something else in a Total Sprint.

Thanks 

Mahanth P 

[Rustem Shiriiazdanov · Accepted solution]

Hi @Mahanth Prudhvi P ,

There are multiple way you may achieve that kind of reporting, actually. I will outline few options here:

1. As correctly mentioned by @Madhu_RVS  you may use Jira API to get the data. I would suggest your team members agree on some naming convention to log their time, so that you could easily group the data extracted for further analysis.

For example, start each worklog with the activity type in brackets:

[Coding] Implemented the login feature.
[Unit Testing] Wrote tests for the authentication module.

Then you may collect worklogs using API (see for example https://developer.atlassian.com/cloud/jira/platform/rest/v2/api-group-issue-worklogs/#api-group-issue-worklogs ). And then perform necessary parsing and data grouping. Let me know if you need any help with this, I could provide some code snippets for that.

2. You may use some applications from marketplace to introduce worklog attributes to categorise your data, so that your team could create worklogs with predefined categories for further analysis. There are many applications available for that. One mentioned  in this thread is https://marketplace.atlassian.com/apps/1230243/worklogs-time-tracking-timesheets?hosting=cloud&tab=overview. But you may also look into other like https://marketplace.atlassian.com/apps/6572/tempo-timesheets-time-tracking-reports?tab=overview&hosting=cloud  or https://marketplace.atlassian.com/apps/1227537/timesheet-builder-time-tracking-and-worklog-analysis?hosting=cloud&tab=overview 

3. As a Product Owner for Actonic Report Builder I must also say a few words about https://marketplace.atlassian.com/apps/1216997/report-builder-jira-tool-for-your-report-and-dashboard?hosting=cloud&tab=overview 

If you don't like to implement your own solution, or use time tracking apps, and if all your team members will create their worklogs in a same format (i.e. just "coding", "Unit testing"), you may use Report Builder to report against your worklog. Example of the outcome is below:

[Mahanth Prudhvi P]

Hi @Rustem Shiriiazdanov 

Thank you for all the solutions. I have not used Jira API's but should definitely get my hands on it to gain it's advantages.

This Addon(https://marketplace.atlassian.com/apps/1216997/report-builder-jira-tool-for-your-report-and-dashboard?hosting=cloud&tab=overview ) exactly meets my expectations  but I will also check the remaining addon's.

Thanks again for the detailed suggestion.

[Rustem Shiriiazdanov]

Thanks @Mahanth Prudhvi P ! 
Feel free to reach me for any help on how to configure Report Builder directly or through Actonic Support portal. Report Builder also directly works with Jira API, so i can provide you a ready-to-use custom report based on APIs for your needs if necessary.

Regards,

Rustem

[Gökçe Karaduman-The Starware]

Hi @Mahanth Prudhvi P ,

Currently, Jira doesn't support categorizing worklogs (e.g., separating them into unit tests and coding) directly. To manage this, you could create separate issues for each category and instruct users to log their work under the relevant issue. Then, you can export with the export all fields feature in jira's issue navigator and prepare your own reports in excel for better visibility.

If you're considering third-party applications, one option is WorklogPRO. This tool offers an attributes feature that lets users select relevant categories when entering worklogs. By implementing a mandatory single-select attribute for categories like coding or unit tests, you can ensure users categorize their worklogs consistently. WorklogPRO supports different attribute types, including boolean, text, integer, duration, decimal, multi-select, and single-select.

If you're interested , you can check the "WorklogPRO Attributes page" for more detailed information.

Disclaimer: I am an employee of the company that developed this app.

[Mahanth Prudhvi P]

Hi @Gökçe Karaduman-The Starware

Thanks for your suggestion

Will try it once.

[Madhu_RVS]

Hi @Mahanth Prudhvi P 

You can use Jira Rest API's to pull this data and build on your own custom solution. Or if you would be interested in a mktplace app , take a look at

Worklogs Time Tracking & Timesheets

You can use the Sprint filter option to search for time spent in a particular sprint. You can easily view time entries for multiple issues day wise grouped by in a single view. The app allows to filter/Categorize/Group your worklogs data and a timesheet view too to track individual time spent. And what's more it can be added as a dashboard gadget. 

Disclaimer : I work for the vendor who built this app

[Mahanth Prudhvi P]

HI @Madhu_RVS  We used it for few months in the past and we would like to go for it again if it fulfills this requirement.

Thanks for your suggestion.

[Gracjan Wesołowski _HeroCoders_]

Hi @Mahanth Prudhvi P 

If you are looking for a time tracking report that would allow you to show more detailed time logged, you can check our app - Clockwork Pro.

We have a feature - custom attributes - tags if you will - to worklogs and then display timesheets that show time spent broken down by those tags. You can also make these fields mandatory. This is what it looks like while adding the worklog: 

If you have any additional questions, related to that topic, let me know.

Cheers!

Gracjan

[Iryna Prokop_SaaSJet_]

Hi @Mahanth Prudhvi P,

Jira’s built-in time tracking does not allow distributing and comparing time based on custom calculations directly.
If you are okay with add-on I can suggest you workaround using Time and Cost Tracker developed by my team.

This add-on integrates smoothly with Jira’s native time tracker, so any worklogs you've previously entered will automatically be included in its reports. 

You will be able to filter Time reports by project, user, time frame and even get more detailed reports using custom filters. 
For instance, you create and save filters that group tasks for coding, UT, etc and generate a separate report for each group.  

Additionaly, you can monitor who is working on which tasks and for how long, compare your initial time estimates with the actual time spent to track project progress and identify opportunities for improvement.

The Time & Cost Tracker simplifies report generation with just a few clicks, allowing you to export them for further analysis or to share with stakeholders. And it’s free for up to 10 users.

[Mahanth Prudhvi P]

Hi @Iryna Prokop_SaaSJet_ 

Will try it once.

Thanks for your suggestion