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.

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.

1. 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)
     
     

     Open

     

     Count of Issues

2. 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.
     
     

   Open

   

   Time to First Response (in min)

3. 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.
     
     

    

4. 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.