YouTrack Standalone 7.0 Help

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.

ValueDescription
Moving maximumThe 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 averageThe 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.

MaximumThe 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.
AverageThe 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.
MinimumThe 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

SettingDescription
Report NameThe name of the report.
ProjectsThe projects for which the report is calculated. The projects that are visible in the list are displayed based on your View Project access permissions.
QueryThe 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.
PeriodThe time frame for which issues are displayed on the report.
Automatically RecalculateConfigures 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.
TypeSets 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.
ValuesDetermines which values for the selected custom field are factored into the calculation of the report.
Moving Window SizeSets 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 toSets 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.

SettingValue
ProjectsYouTrack
QueryEmpty
PeriodThis month
TypeState
ValuesSubmitted, Open, In Progress, Fixed, In Testing, Verified
Moving Window SizeMonth
/help/img/youtrack/7.0/averageIssueAge.png

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.
ValueDescription
Moving maximumReturns 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 averageReturns 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.
MaximumReturns the largest duration in the set.
AverageReturns 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.
MinimumReturns the shortest duration in the set.

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

ValueDescription
Shifted to another stateThe 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: 2 December 2016