JIRA: How do you calculate the Average Days Open for all Issues within a month ?

Aurelie Menard November 9, 2017

Hi,

To evaluate productivity, I would like to calculate how long in average our issues were open for, from 1st to last day of each month.

Does anyone know how to do this in JIRA?

Thank you!

1 answer

0 votes
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 9, 2017

Hello,

You can use Average Time In Status Gadget.

1. Create a filter which selects required issues.

2. Add Average Time In Status Gadget to your dashboard

3. In the gadget settings choose the filter, period - monthly, statuses - open.

You will get the required information.

Aurelie Menard November 9, 2017

Thank you very much for your answer Alexey. How do I access Status Gadget?

Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 9, 2017

Kindly read the following article. You will find there how to create dashboards and add new gadgets. Just when you add a gadget find the Average Time in Status Gadget.

https://confluence.atlassian.com/jirasoftwarecloud/configuring-dashboards-764478209.html

Aurelie Menard November 9, 2017

Sorry I should have been more specific, I know how to create a dashboard and add gadget but I don't find "status gadget" nor Average Time.

Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 9, 2017

Hello,

I just double checked it. This gadget must be in Jira Core according to the article

https://confluence.atlassian.com/jiracorecloud/gadgets-for-jira-applications-765593584.html

Maybe when you pushed Add gadget not all gadgets were loaded. 

Choose All category and there will be a button "Load All Gadgets"

You can read more here

https://community.atlassian.com/t5/Jira-questions/Not-all-gadgets-have-loaded/qaq-p/167723

Aurelie Menard November 14, 2017

I did click on "load all gadget" but can't see Average Time in Status.

I tried "Average Age Chart" and "Resolution Time" and not sure to understand the difference except that for the same period, "Average Age Chart" shows an ADO of 50 days (! quite unlikely) and "Resolution Time" shows an ADO of 2 days (but only focus on resolved issues)

Suggest an answer

Log in or Sign up to answer