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.
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)
Count of Issues
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.
Time to First Response (in min)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.