Average Issue Age

This report is optimized to track the average length of time that issues spend in specific states.

If you have a service-level agreement to respond to support requests within a specified time frame, you can use this report to monitor your response time. You can create separate reports that show how much time an issue spends in the Submitted, Open, and In Progress states and track the amount of time it takes your team to respond to and resolve issues.

For best results, be as granular as possible. When you configure the report to display values for a single state, you can isolate and identify problems faster. To track each type of activity, create separate reports for different states.

When the report is calculated, a Days line graph displays the moving maximum and moving average length of time that issues spend in the specified states. The line graph calculates the following values for issues that are considered for the report. For a detailed description of these calculations, see Calculations.

Value	Description
Moving maximum	The maximum duration that any issue is assigned the specified state or states within the moving time window that is set for the report. This value will always be less than the period that is set for the moving window size. Spikes in the moving maximum occur when the duration for the oldest issue exceeds the period that is set for the moving time window. As soon as the maximum duration is greater than the moving time window, it is excluded from the calculation. The line drops to the value of the longest duration that is within the moving time window. Use this as an indication that an issue has spent too much time in the selected states.
Moving average	The average duration that all issues are assigned the specified state or states within the moving time window. Spikes in the moving average occur when the duration for the oldest issue exceeds the period that is set for the moving time window and is excluded from the calculation.
Maximum	The longest duration that any issue is assigned the specified state or states at each point in time. Enable this option to view the oldest value that is outside the moving time window.
Average	The average duration that all issues are assigned the specified state or states at each point in time. Enable this option to see if the average duration spent in the selected states is higher than the period that is set as the moving time window.
Minimum	The shortest duration that any issue is assigned the specified state or states at each point in time.

The following options are available in the line graph:

Select a label in the legend to show or hide the corresponding lines in the report.
Move the pointer over a point in time to display the calculations for each of the values on the graph.

The report also includes an Issues bar chart. This chart displays a daily total of issues that are in the selected states, shifted to another state, or both. The following options are available in the bar chart:

Select a label in the legend to show or hide the corresponding values in the report.

Prerequisites

To use this report, configure each project that you include in the report according to the following guidelines:

Use the same custom field to store values as a state type. This can be the default State custom field.
The set of values that is used for the state-type field in each project must contain the values that are used for the Type setting.

Settings

Setting	Description
Report Name	The name of the report.
Projects	The projects for which the report is calculated. The projects that are visible in the list are displayed based on your View Project access permissions.
Query	The Query and Projects settings let you narrow the scope of your report to receive more precise results. The search query field supports the same syntax and auto-completion that are available in the search box.
Period	The time frame for which issues are displayed on the report.
Automatically Recalculate	Configures periodic recalculation for your report. If you select Never, then the option is switched off. You can only refresh the report manually. If you select any of the other options, YouTrack checks if the selected time period has elapsed when you open the report. If yes, the report is recalculated automatically. Reports with auto-recalculation enabled can still be recalculated manually.
Type	Sets the custom field for which the report is calculated. This setting is restricted to display specific custom fields that store single values for an enumerated type. You can calculate this report for any custom field that stores an `enum[1]`, `ownedField[1]`, `state[1]`, or `version[1]` type.
Values	Determines which values for the selected custom field are factored into the calculation of the report.
Moving Window Size	Sets the period that is used as the basis for calculating the moving maximum and moving average age. For best results, set the time window one setting higher than the amount of time you expect issues to remain in the selected states. For example, if you expect issues to remain in the selected states for one week or less, use the Two weeks setting. This helps you see when issues spend too much time in the selected states and keep the average below the expected level.
Visible to	Sets the visibility for the report. By default, the report is visible to its owner only.

Example

A report with the following settings calculates the average age of issues in the YouTrack project by state.

Setting	Value
Projects	YouTrack
Query	Empty
Period	This month
Type	State
Values	Submitted, Open, In Progress, Fixed, In Testing, Verified
Moving Window Size	Month

Calculations

The values that are displayed on the Days line graph are calculated as follows:

For each issue that matches the project and query, the report returns the interval that an issue has been assigned the selected states. Each interval is identified with a start and end timestamp.
The report selects only intervals that intersect the Period setting for the report.
The intervals are separated into days according to the time zone setting of the YouTrack server. Each duration represents the amount of time each issue has been assigned the selected state at the end of each day.
The set of durations is collected for each day that is included in the period.
Each value that is displayed on the report is calculated based on the set of durations for each day.

Value	Description
Moving maximum	Returns the largest duration in the set that is lower than the moving window size. The moving window size is the period that is selected in the Moving Window Size setting.
Moving average	Returns the average duration of all values that are lower than the moving window size. This value is calculated as the sum of the set of values that are lower than the moving window size divided by the number of durations in the set that are also lower than the moving window size.
Maximum	Returns the largest duration in the set.
Average	Returns the average duration of all values in the set. This value is calculated as the sum of the set of values divided by the number of durations in the set.
Minimum	Returns the shortest duration in the set.

The values that are displayed on the Issues bar chart are calculated as follows:

Value	Description
Shifted to another state	The total number of issues that moved from any of the selected states to any state that is not selected in the Values setting for each day. Issues that transition from a selected state to another selected state are not included in this calculation.
In selected state(s)	The total number of issues that remained in any of the selected states for each day.

Last modified: 7 March 2019