Max Issue Age KPI

Step 1: Identify Jira issues to be analyzed by configuring them within the Data Source, e.g., Status was not in Resolved / Closed/ Done from past x days to today, Issue type is ‘Support’, etc.

Step 2: Select the metric ‘Time since’ and pick the ‘Created’ Jira date field for ‘Event’. Apply customizations based on your preferences. Please not that the ‘Measure until’ button is set to until resolved by default. You can keep it like this as it won’t affect issue age of open issues, which is the aim of our report. Its behavior is explained in the Time Since metric article.

Step 3: Use ‘Issue Key’ or ‘Issue summary’ for ‘Display by’ to get metric data distinguished by Jira issue.

Step 4: (Optional) Use ‘Stacked by’ mode to see the metric distribution by any chosen field, metric, or data source. In the provided example, we have not utilized the stack option.

Step 5 Choose vertical orientation of the chart. It will allow more items to fit on the y-axis, as the height in Jira dashboard is better suited to be extended.

Step 6: Switch on Target section and leave the ‘Fixed’ tab selected.

Step 7: Set target results to be calculated against each x-axis item.

Step 8: Define target level. In the sample configuration it is 3 days.

Step 9: Mark target as negative by setting ‘Exceeding’ is: ‘Bad’. Therefore, if the target is exceeded, the results will be colored in red.

Step 10: Under ‘More Settings’ section, enable the ‘Warning threshold’ and set a number as fixed value or as % of target. It will color the results above that level and below target in Amber.

Step 11: Enable the ‘Custom Target Label’ and set label to indicate the negative type of the Target on the chart, e.g., ‘Max age (d)’.