Created vs resolved issues over time

On this page:

Overview

This report shows how many issues have been created and resolved over a time period together with average resolution days and open issues. 

How to build it

To build this report start with table view and in the Measures dimension select measures Issues createdIssues resolved, Average resolution days and Open issues.

  • Issues created measure is the total number of created issues that match selected dimension members. The measure is grouped by issue creation date on Time dimension.
  • Issues resolved are the issues that have resolution and resolution date. The measure is grouped by issue resolution date on Time dimension.
  • Average resolution days calculate what is the average resolution days for issues that are resolved. The formula is total resolution time divided by how many issues have been resolved. The measure is grouped by issue resolution date on Time dimension.
  • Open issues calculate what is the number of unresolved issues at the end of the corresponding Time dimension period or how many issues have been created and are still without the resolution. The measure counts issues since the beginning of the time until the end of the selected time period.

Use Time dimension in Rows. Configure Time dimension as is more comfortable, e.g. Monthly to see how many issues were for each measure at the end of each Month

Add the same Time dimension to Pages for filtering report data and select predefined calculated member Last 12 months from Time dimension, use it to filter the report data. In Pages also select dimensions ProjectIssue type, Priority and Assignee for report filtering.

To show this report as chart switch to Line chart and for measures Issues created and Issues resolved change the chart type to column. For measures Average resolution days and Open issues use two separate axes options. For Average resolution days axis add suffix ' days' to represent metric used for this axis.

See also