/
Unresolved Issues by Overdue State & Status

Unresolved Issues by Overdue State & Status

We've introduced a new 'Overdue State' field, which can be used in the Display by, Group by, and Stack by options within the app's gadgets to categorize issues based on their due date status. Below is a sample report demonstrating how this can be utilized in a Jira dashboard.

UnresolvedIssues-by-Overdue-Statte.png

Hovering over the chart results and clicking on any segment will take you to the issues within that segment in the Jira Issue Navigator. This is particularly useful for viewing a list of overdue issues and offers functionality that goes beyond what a JQL query in Jira can provide.

To configure Unresolved Issues by Overdue State & Status report in Jira, follow the simple steps below:

Step 1: In the data source, disable the Date Range, select the project you wish to analyze, and enter the following JQL query: resolution is EMPTY AND duedate is not EMPTY to filter for unresolved issues that have a due date assigned.

Step 2: Keep the default metric selection “Number of issues”.

Step 3: Display by the “Overdue state” field configured from Actual date (Resolved) to Due date.

Step 4: Stack by “Status” field, or other field that is relevant to your analysis.

Overdue-state-settings.png

Step 1 in detail:

data-source-settings.png

 

Step 3 in detail:

Overdue-state-field.png

 

Let’s explain the behavior of the “Overdue State” field. When configured from “Resolved” to “Due date”, it categorizes issues based on their due status as follows:

  • Due: Issues that have not yet passed their due date. If resolved, it indicates the issue was completed before the due date. If unresolved, the issue is still within the due date range.

  • Overdue: Issues that have passed their due date, regardless of whether they are resolved or unresolved.

When using a Custom Work Calendar with combination to this field, the due date is considered reached at the start of the working hours on that date.

For example: if the due date is April 21 and the workday starts at 9:00 AM: An issue resolved at 8:00 AM will still be categorized as Due. An issue resolved at 10:00 AM will be categorized as Overdue.