How do I build a report to show how long an item has been assigned to a particular user "this" week?

Question

Hello Jira community,

I want to build a report using structure or JQL that lets me see how long an item has been assigned to a user for the current week, preferably using just work hours. I want to do this so I can speed up the process for calculating the time developers spend on their work during the week. I don't want to add any manual process otherwise I would have them track it themselves on the issue.

Any ideas for how to build a report like this? What sort of setup/data would I need to make this happen?

Stepan Kholodov _ALM Works_ · Answer

Hello @jtrevag

We just released Structure version 7.4 and among other features, it includes the support for History in the Formula column. You can resolve the described use-case with a formula like this:

with start=make_date(2021,12,20):
with finish=today():
with assignee_set=history.filter($.time > start and $.time < finish and $.changes.any($.field = "assignee" and $.to = "assignee name")).time.last():
days_between(assignee_set, today())

The Formula will determine the date when the Assignee was changed to the particular user this week and then calculate how many it's been since that date. You can convert the days into hours additionally and use a more dynamic approach with the start variable.

I hope this helps. If you need further assistance with the Formula column, please contact us directly at support.almworks.com

Best regards,
Stepan Kholodov
ALM Works

Kirill Medvednykov · Answer

Hello jtrevag

If you are using a scrum board for your project, you can try this app Simple Time Tracker Report for Jira. It allows you to get time reports by every task and developer in a sprint. This is a 100% free app.

Best regards

Stepan Kholodov _ALM Works_ · Answer

Hello,

I'm afraid it is not possible in Structure - sounds like the described can be achieved by having some history-based solution and Structure doesn't have access to the history in Jira at this time.
As for running a JQL search in Jira - it is possible to search for issues that were assigned to a particular user and then re-assigned to a different one using the was and changed operators, but the results won't show any actual time of how long the assignment lasted.

But maybe somebody else can recommend some solution here, possibly using another app.

Best regards,
Stepan Kholodov
ALM Works