This article provides a workaround to display the total values on the report when the aggregation is set to Averageaverage.
Scenario: Create a list report to display the total count of issues and the average time taken for the first response in minutes.
Instructions
To achieve the desired outcome of displaying display total values with average aggregation for the data fields, create three calculated fields. Consider the Time to first response: elapsed(ms) field.
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.
