Duration from unassigned to assigned

[ivana_bogojevic]

Hello Team,
Is there a way to show in the dashboard how long it took to change the status from unassigned to assigned?

[Jack Brickey]

Hi @ivana_bogojevic , welcome to the community.

There are a couple of ways you could approach this. 

• consider using a third-party app.
• Create a custom field and use automation to populate that field with the time between the created date and the assigned date. Trigger - field updated on Assignee field, action edit issue and use smart values to calculate the difference between now and created date. There are a number of posts that present example rules for this and the documentation on Automation is also quite helpful. If you decide to proceed with this solution and need further assistance, just let me know I'm happy to give you further assistance.

the one thing to consider is how you want to handle issues that might fall into this scenario: unassigned > assigned > unassigned > reassigned

[ivana_bogojevic]

Hi Jack
Thank you for your reply. I will try this and get back to you should I have any questions :-)

[Hannes Obweger - JXL for Jira]

Hi @ivana_bogojevic

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, your use case should be easy to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including the time with [assignee] and time unassigned.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[ivana_bogojevic]

Hi Hannes

That would be great and it looks really good. But I have to ask my company if they would agree with a subscription as it's unfortunately not included in our payment plan

Greetings
Ivana