Report to see in same status for many days

Question

Hi,

We have a user requirement to generate report/gadget in dashboard where we can see the issues stuck in same status for long .Is there any way we can achieve this result.

Regards,
Suma

Hannes Obweger - JXL for Jira · Accepted Answer

Hi @Suma Kustagi

getting an issue's time in the current status is a common problem (you should find a couple of questions here), and unfortunately a tricky one.

If you want to filter all issues that have been in their status for longer than a particular duration, have a look at these examples, all involving the CHANGED operator:

https://mraddon.blog/2016/04/01/jira-jql-trick-filter-issues-based-on-transition-state-execution-date-in-jira/

There's also the

statusCategoryChangedDate

field in JQL, but as the name implies, if only captures status category changes, not status changes within the same status category. Depending on your exact use case, this may or may not be sufficient.

If you also want to view the exact time in status, there's a couple of other options that I can think of - however I haven't tried them myself, so perhaps someone else can lean in:

* In Jira Service Management, the concept of SLAs might allow showing the time in status - however this doesn't work for Jira Software.
* If you use Jira Automation, you might be able to calculate the time in status, through a rule that is executed regularly and compares the time of the last status change to the current time. I did a quick search but couldn't find a concrete answer, so this may or may not be possible.

Lastly, there's a number of apps in the Atlassian Marketplace that allow surfacing the time in status, either through special custom fields, or through their own visualisations. As you may have heard, apps sales have been stopped for Jira Server - so you'll have way more options if you migrate to Data Center or Cloud. This being said, depending on the app, you may be able to work something out directly with the vendor. I myself happen to work on an app that shows the time in status and still can be added to Jira Server directly through us; I'll add more details below.

Hope this helps,

Best,
Hannes

Bill Sheboy · Accepted Answer

Hi @Suma Kustagi -- Welcome to the Atlassian Community!

You can do this with out-of-the-box features, using a JQL statement such as this one:

project = myProjectName 
 AND NOT status CHANGED AFTER -5d
 AND statusCategory = "In Progress"
 ORDER BY key ASC

That would list the in-progress issues in your project which have not changed status in the last 5 days, which you can adjust to meet your needs.

Next, you could save that filter, and either:

* create a subscription to it so you (and others) receive emails with the issues, or
* use a dashboard gadget to list the results.  For example, the Filter Results, or Two Dimension Filter Statistics gadgets, or several others.

Kind regards,
Bill

Lucy Warner_SaaSJet · Accepted Answer

Hello @Suma Kustagi

If you're ok with using third-party add-ons, you can try Time between Statuses developed by my SaaSJet team.

All you need is to set a necessary status as Start and Stop timers - and get the time in a particular status. Then you can export it as XLSX or CSV files for further analysis.

You can get a 30-day free trial version or just ask me a question if you have some.

HOpe it helps

Mehmet A _Bloompeak_ · Accepted Answer

Hi @Suma Kustagi

Welcome to Atlassian Community!

As an alternative, 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.

* This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

* You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
* Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
* You can set different duration formats.
* You can export reports in CSV file format and open them in MS Excel.
* You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
* You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

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

Hope it helps.

Emre Toptancı [OBSS] · Accepted Answer

Hello  @Suma Kustagi ,

I will recommend Time in Status which is built by my team at OBSS. It is available for Jira Server, Cloud, and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status.

The two important features of our app that applies to your use case are:

* You can filter and sort issues based on the reported time for a status (or the total time for a group of statuses)*

* For issues that visit a status multiple times, you can report on the time for the total time spent on that status or only the time for the first or last visit.

Time in Status 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.

Time in Status 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.

https://marketplace.atlassian.com/apps/1211756/

EmreT