Displaying total values with average aggregation for data fields

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:

1. The first calculated field creates a Count of Issues field. The expression is:
   IF ELSE(NOT(IS NULL(Issue Key)), 1, 0)
   

   

2. The second calculated field converts the Time to first response: Elapsed (ms) to minutes. The expression is: MULTIPLY(DIVIDE(Time to first response: Elapsed, 60000), 1)
   

   

3. The third calculated field replicates the Time to first response: Elapsed field but in minutes. It is based on the first and second calculated fields. The expression is: MULTIPLY(DIVIDE(Time to First Response(in min), Count of issues), 1)
   

   

4. Create a report by selecting this field: Average Aggregation(in min) instead of the Time to first response: Elapsed(ms) → Run → Save the report. The results are as follows.