Average Issue Age by Priority
Step 1: Define your Data Source.
Step 2: Choose ‘Time Since’ metric and apply Average calculation.
Step 3: for Display by select ‘Issue type’ field.
Step 4: Group by 'Priority'
In this report, we utilize the ‘Time since’ metric to calculate the average age of all issues filtered within the data source, irrespective of their resolution status. When setting up the metric, you’ll notice that the “Measure until Resolved” button is selected by default, which calculates time in the following way:
for resolved issues, it measures the time elapsed from creation to resolution
for open issues, it calculates the time from creation until the present moment
Should you wish to assess the age of the issues exclusively for closed or open issues, you can customize this within your data source settings. Additionally, in certain contexts, you may find it beneficial to utilize the “until now” selection.