Regarding "Average Number of Time in Status" getting value as zero

[Shantu Chatterjee]

Hi There,

When I am creating a dashboard with "Average Number of Time in Status", I am getting the time as zero for each status.

Please see the screen shot.

Thanks.

[Julia Shcherbyna _SaaSJet_ · Accepted solution]

Hi @Shantu Chatterjee 

You can also try Time in Status for Jira Cloud app from Marketplace (create by my team).

Using it you can generate Average time in status report and add it Jira dashboard as a gadget. Data could be present in table and chart views.

Hope it helps.
Regards

[Shantu Chatterjee]

Thanks a lot Julia, it works for me.

[Rahul_RVS]

Hi @Shantu Chatterjee 

If you would be interested in an add-on to get this data, you can try out our plugin,

Time in Status Reports 

The add-on provides the time in each status for the entire lifecycle of the issue and you can filter by issue type as well. You can also combine your statuses to define your lead/cycle/resolution time and also extract the transitions history of the issues. The main features of the app are as below

• More than 8 types of Time in Status Reports. Excel Export available for all status reports.
  
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports
  • Avg Time in status reports
• Status grouping
• Save your reports
• CSV Export
• Multiple chart types

[Julien Lavy]

So the Jira version just doesn't work?

[Mehmet A _Bloompeak_]

Hi @Shantu Chatterjee ,

Could you please share the screenshot for both the gadget view and configure screens?

[Shantu Chatterjee]

Hi,

Here is the screen shot of Confi

[Mehmet A _Bloompeak_]

Hi @Shantu Chatterjee ,

There might be a problem with the filter, other than that your config seems ok.

As an alternative you can use Status Time app which is developed for this exact need. It provides reports on how much time passed in each status, status entry dates and status count.

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. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try.

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