This article provides a workaround to display the total values on the report when the aggregation is set to Average.
\uD83D\uDCD8 Instructions
Create 3 calculated fields to get the expected outcome:
...
average.
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 display total values with average aggregation for the data fields, create three calculated fields.
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.
