Upgrade to the latest Atlassian release of the Jira software version 9.4.11, 9.10.2, 9.11.1 or higher, which includes the MySQL 8.x fix, and the ActiveObjects library upgraded to version 5.0.3. Refer to Issues resolved in 9.4.11.

Jira: Open Issues by Age

Owned by Nisha Shantilal
Last updated: Oct 31, 2023
2 min read

This article explains how to create a report which shows Count of Open Issues in Jira by Age buckets.

Age buckets: < 1 day, 1-3 days, 3-5 days, +5 days

Instructions

The report is created using Reports and Timesheets for Jira app.

  1. Create a calculated field to define the age buckets

    1. Go to Jira > Reports and Timesheets > My Area > My Calculated Fields > Create New Field

    2. Create a calculated field by adding functions and fields as per the screenshot below

       

  2. Create a List report

    1. Go to Jira > Reports and Timesheets > Custom Report

    2. By default report type is selected as List

    3. Click on the fields in the left hand side fields selector to add them to the report

      1. Project: Project Name. Add group on Project.

      2. Common: Issue Type, Current Status, Count of Issues

      3. Calculated: Age

         

  3. Add filters and hide fields that are not required

    1. To report on only Open issues, click on the settings icon of Current Status field, add a filter and hide the field

       

    2. To report on only specific issue types, click on the settings icon of Issue Type field, add a filter and hide the field

       

  4. Run the report to view the results

     

  5. The same report can also be created as a Bar Chart or a Matrix report

Related articles