Page Comparison

...

\uD83D\uDCD8 Instructions

Create 3 calculated fields to get the expected outcome:

...

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 will count the number of issues. The expression is

   :

   • 
     IF ELSE(NOT(IS NULL(Issue Key)), 1, 0)
     

     Image Modified

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

   

   The third calculated 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

   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)
     

   

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

4. Add the calculated field to the report:

   • Create a report by selecting

   this

   • the field

   :

   • "Average Aggregation (in min)" instead of

   the

   • "Time to

   first response

   • First Response: Elapsed (ms)

   → Run → Save

   • ".

   • Run and save the report. The results

   are as follows

   • should now display correctly with both sum and average values.
     

     Image Modified