nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Time to Assign Issue?

Rostam Kilgour

Hi All

I'm trying to find a way to find the time it takes to assign an issue. We have an automated intake of issues into a project (genetrated from a mixture of Jira Automation, and Power Automate), they land with no assignee. Issues are then assigned as we consider each issue depending on the skills required to solve the issue.

Essentially I'm trying to find the time stamp of when an issue was first assigned, and will deduct the created time stamp. I'd ideally like to do it in Power BI, on in a Jira native dashboard. When I expand the assignee record in Power BI there is no date of assignment. I can't see any other columns that would have this information in, or a record of status changes.

The reason for asking this is because the time to assignment is presently way too long for our team, and I want to be able to create a display that shows this!

Accepted answers

Amay Purohit_RVS

Hi @Rostam Kilgour

You can use Jira Rest API's to pull this data if you are looking to track multiple issues at once. Or you can check the history tab if you need this information for a handful of issues.

Another option could be to use a mktplace app. If you would be fine to try out one, take a look at

Time in Status Reports

Couple of reports provided by the app can help to get this data, "First Transition to Assignee" and "Time with Assignee. For Time with assignee you can see how much time the issues were in "Unassigned" state.

This data can be easily exported to Power BI using the JSON Feed feature provided by the app itself.

Also the app has 20+ reports to meet a variety of time in status use cases. Do give it a try.

More Details here

Disclaimer : I work for the vendor who built this app

Transtion to Assignee.PNG

Dave Rosenlund (Trundl)

Hi, @Rostam Kilgour. First, I moved your question to the Automation group where someone smarter than me (when it comes to Automation) may be able to help you.

And to add to what @Amay Purohit_RVS had to say, there are a number of apps in the Atlassian Marketplace that do this. The screenshot below is only showing the first six results 😎

Screenshot 2024-07-22 at 8.18.42 AM.png

https://marketplace.atlassian.com/addons/app/jira/top-rated?hosting=cloud&moreFilters=cloudFortified&moreFilters=vendorSupported&query=%22time%20in%20status%22

Hope this helps,

-dave

Rostam Kilgour

Hi All

Thank you for all your suggestions. I'm sure they all work well, however they all cost and I was hoping to be able to get this information out using already available tools.

A slightly less elegent way, but free, will be to create a Custom Field (Date/Time format) and update it whenever someone is assigned to a task (for the first time). I'm probably going to embark on this route unless anyone else has a free suggestion?

Thanks

All comments

Amay Purohit_RVS

Hi @Rostam Kilgour

You can use Jira Rest API's to pull this data if you are looking to track multiple issues at once. Or you can check the history tab if you need this information for a handful of issues.

Another option could be to use a mktplace app. If you would be fine to try out one, take a look at

Time in Status Reports

This data can be easily exported to Power BI using the JSON Feed feature provided by the app itself.

Also the app has 20+ reports to meet a variety of time in status use cases. Do give it a try.

More Details here

Disclaimer : I work for the vendor who built this app

Transtion to Assignee.PNG

Dave Rosenlund (Trundl)

https://marketplace.atlassian.com/addons/app/jira/top-rated?hosting=cloud&moreFilters=cloudFortified&moreFilters=vendorSupported&query=%22time%20in%20status%22

Hope this helps,

-dave

theCode4_company

Hi @Rostam Kilgour

As mentioned in the previous comment, you can try using the REST API for this matter. Here is a handy link for this topic:
How to connect Power BI to JIRA using Rest API and without third-party apps.

If you are open to using third-party apps, we are happy to offer our PRO solution of the Exporter for Jira app, which includes a Field Change History option with Assignee and Created fields selected.
time to first assignee.png

Once the data is exported to Power BI, you will be able to create a report based on the TimeInOldValue data, where the issue was unassigned (empty field).
time to first assignee_power_bi.png

Additionally, you can set up scheduled refreshes so that the report is automatically updated in Power BI as new issues are created.

If you need further support, please feel free to contact us.

Best regards,
theCode4 Team

Hannes Obweger - JXL for Jira

Hi @Rostam Kilgour

As you can see from the previous answers, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their reporting needs.

If a Marketplace app is an option for you, I think you'll like 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 number 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; you can 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.

Any questions just let me know,

Best,

Hannes

Valeriia_Havrylenko_SaaSJet

Hi @Rostam Kilgour 👋

As @Dave Rosenlund _Trundl_ mentioned there are various add-ons over marketplace to try. So if an app from the Atlassian Marketplace should become an option for you, you may want to have a look at the app that my team and I are working on, Time In Status.

I am going to show you how to find the time it takes to assign an issue in a few clicks:

Choose Time in Status report
Filter by JQL assignee = empty
Enjoy your report!

Знімок екрана 2024-07-22 о 23.18.39.png

You can also book a live demo - we'll show you the application inside out and answer all your questions.

Have a nice day 🥳

Gizem Gökçe (OBSS)

Hello @Rostam Kilgour ,

My recommended app for you is Timepiece - Time in Status for Jira app, the oldest and leading Time in Status app in Atlassian Marketplace, which is built by my team at OBSS. It is available for both Jira Cloud, and Data Center.

There are two ways to find out how long it takes to assign an issue.

The first is to use the Assignee Duration report. In this report you can see how much time each assignee has spent on each issue. Unassigned is also a column, so from this column you can easily see how much time this issue spends when it has no assignee.

Time to Assign Issue Assignee Duration Report.png

Your second option is Assignee Duration per Status Report. This is a more detailed version of the first report. In this report you can also see the time spent on each status separately.

Time to Assign Issue Assignee Duration per Status Report.png

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily.

Visit Timepiece - Time in Status for Jira to explore and enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

Mehmet A _Bloompeak_

Hi @Rostam Kilgour

Jira doesn't have a built-in solution for assignee time. If you prefer using a marketplace app, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Time in Assignee report. Unassigned column (as can be seen on the screenshot below) is what you are looking for.

Time in Assignee.png

For further details, you can have a look at Status Time Reports How to Videos.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

Rostam Kilgour

Thanks Dave

Rostam Kilgour

Hi All

Thank you for all your suggestions. I'm sure they all work well, however they all cost and I was hoping to be able to get this information out using already available tools.

Thanks

Mehmet A _Bloompeak_

Hi @Rostam Kilgour

If you are looking for a completely free solution, you can try Status Time Reports Free which is the limited version of Status Time Reports.

Hope it helps.

Maksym Babenko_TypeSwitch_

Hi @Rostam Kilgour!

I’m part of the team behind Flow Time Report, a Jira Cloud app that tracks how long each issue stays in every status, including how long it remained unassigned or in "To Do" before being picked up.

It’s a simple way to get this visibility without setting up custom automations or reports.

➡️ Free: https://marketplace.atlassian.com/apps/1237782

Happy to help if you have questions!

Bill Sheboy

Hi @Maksym Babenko_TypeSwitch_

Please review the community guidelines regarding "necro-posting" to older threads, particularly as a vendor:

https://community.atlassian.com/forums/custom/page/page-id/rules-of-engagement

Kind regards,
Bill

Maksym Babenko_TypeSwitch_

Thanks, Bill, will do!

SilkeS

@Maksym Babenko_TypeSwitch_ , if you're part of a Marketplace App team, we would like to ask you to follow the steps outlined here to get an 'Atlassian Partner' lozenge for your profile! Cheers!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation