...
Create a new calculated field for counting issues
This field counts the number of issues.
The expression is
IF ELSE(NOT(IS NULL(Issue Key)), 1, 0)
Create a second calculated field to convert ms to min:
Consider the Time to first response: Elapsed(ms) field.
The expression is:
MULTIPLY(DIVIDE(Time to first response: Elapsed, 60000), 1)
This expression converts the elapsed time from milliseconds to minutes.
Create a third calculated field for the average time to the first response in minutes:
This field replicates the "Time to first response: Elapsed" but in minutes.
It is based on the first and second calculated fields created. The expression is:
MULTIPLY(DIVIDE(Time to First Response(in min), Count of issues), 1)
This expression calculates the average time to first response in minutes.
Add the calculated field to the report
Create a List report and add the fields as shown.
Select the calculated field "Average Aggregation (in min)" instead of "Time to first response: Elapsed (ms)".
Run and Save the report.
Outcome: The report displays the sum of the number of issues and the average time to the first response in minutes.