Tracking the total time logged by a user during a sprint

[kanchana wijerathna]

One of our User is willing to get following stats in dashboard

I am trying to create a dash board where I can see the time logged by each user during a sprint.

e.g: The total time logged by user A during sprint Y.

Is there a way to take this stat?

Currently I can only take the list of issues where user X logged time during sprint Y. But is there a way to track how many hours a particular user has logged during a sprint?

is this achivebale ?

[Sebastian Brudziński]

@kanchana wijerathnathis is easily achievable using our Worklogs - Time Tracking and Reports.

Here are the steps to make it work the way you want it (after installing Worklogs)

1. Add "Worklogs" gadget to the dashboard
2. Create JQL filter that contains the tickets you want to track time for. In your cause you mentioned current sprint, which might look like this: JQL: sprint in openSprints() and sprint not in futureSprints()
3. Go to "Edit" in Worklogs gadget and select the created filter. Also pick "User" in option Categorize By
4. Save and check the results, it should look similar to this:

If you would rather display time logged each day or each week during the sprint, rather than a total, you can change the "Period grouping" option accordingly. You can also limit the users that are displayed in the "Users or groups" dropdow. You can also use "Group by" to display additional grouping, like the project or issue type each user logged the time to.

Hope this helps!
Sebastian

[Hugo Winder]

Hi Sebastian,

I hope you don't mind me going after this old comment. This solution seems to be working quite well, the only issue I now have is that the option in the widget: Date range does not translate to the active sprint. 

This is my example case, some stories were not finished in the previous sprint and are being brought along to the next one. After you start the new sprint is seems to show the hours of the old sprint if you don't fix the date range. If I set the date to today it is correct though, but that would mean I will have to change this every day. 

Hope you have an idea for this.

Hugo

[Ewa Grabowska-Ptak_SolDevelo_]

Hello @Hugo Winder,

Thank you for sharing your case with us. Unfortunately, at this moment we do not offer a date range to fit precisely the active sprint. Thus, it might happen that the Time Logs made in previous sprint can be visible in a new sprint in this scenario. 

Our Team is already planning on developing improved ways to view current sprints. So, I am glad to see your comment now. I will share it with our team to consider while developing a new feature. I'll also keep in touch and contact you once we have it released. 

Please feel free to share your needs or ideas with us, we truly appreciate your feedback.

Best regards,

Ewa

[Hugo Winder]

Hi @Ewa Grabowska-Ptak_SolDevelo_ ,

In the meantime, I found your Trello board, also voted on the story there. If there is any desire from your team, I can provide some extra explanation in the story.

Thanks,

Hugo

[Fazila Ashraf]

@kanchana wijerathna  , this is achievable with a commercial plugin but AFAIK not out of the box.

See https://marketplace.atlassian.com/apps/294/timesheet-reports-and-gadgets?hosting=server&tab=overview

You might have to configure the time window of your sprint manually in the gadget but it would get the timesheet format report