Displaying total values with average aggregation for data fields in the Reports and Timesheets for Jira app

This article provides a workaround to display the total values on the report when the aggregation is set to Average.

Instructions

To achieve the desired outcome of displaying total values with average aggregation for the data fields, create three calculated fields. Consider the Time to first response: elapsed(ms) field.

1. Create a calculated field for counting issues:

   • This field counts the number of issues. The expression is
     IF ELSE(NOT(IS NULL(Issue Key)), 1, 0)
     

     

2. Create a second calculated field to convert ms to min:

   • This field converts the "Time to first response: Elapsed (ms)" to minutes. The expression is: MULTIPLY(DIVIDE(Time to first response: Elapsed, 60000), 1)
     

   

   This formula converts the elapsed time from milliseconds to minutes.

3. Create a third calculated field for average time to 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. The expression is:
     MULTIPLY(DIVIDE(Time to First Response(in min), Count of issues), 1)
     

   

   This formula calculates the average time to first response in minutes.
   

4. Add the calculated field to the report:

   • Create a report by selecting the field "Average Aggregation (in min)" instead of "Time to First Response: Elapsed (ms)".

   • Run and save the report. The results should now display correctly with both sum and average values.