Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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)

      2024-07-22_19-50-42.png
  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.

    2024-07-22_19-50-55.png

  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.

    2024-07-22_19-51-10.png

  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.

      2024-07-22_19-47-47.pngImage Removed2024-07-22_19-47-47.pngImage Added