Versions Compared

Key

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

This article helps you to display a report having with the percentage of SLA execution based on the Time spent resolving each case in the list view.

Instructions

Create a Calculated field to convert Time to resolution target in seconds

  1. Navigate to Apps and select Reports and Timesheets.

  2. Navigate to My Area and select the My Calculate field. Click on Create New Field.

    image-20240325-110412.pngImage Removedimage-20240325-110412.pngImage Added

  3. Create a Calculated calculated field to convert Time time to resolution target in into seconds because it shows in milliseconds in reports. We As we have converted this to into seconds, and the Time spent field is in seconds, so the values should match to calculate the percentage in seconds.

...

  1. image-20240219-070137-20240325-110033.pngImage Added

Create another calculated field to compute this percentage.

  1. Navigate to Apps and select Reports and Timesheets.

  2. Navigate to My Area and select the My Calculate field. Click on Create New Field.

  3. Create another calculated field to compute this percentage. The As mentioned above, the "time to resolution" field is a calculated field we have created, as mentioned above. The formula here is (Time spent/Time to resolution target)*100

    image-20240219-070245-20240325-110743.pngImage Removedimage-20240219-070245-20240325-110743.pngImage Added

Create a custom report.

  1. Navigate to Apps and select Reports and Timesheets.

  2. Navigate to Nre New Report and select Custom Reports.

  3. Select view type as List.

  4. Add fields like Issue key, Time Spent, and Time to resolution target, and also add the calculated field Time to resolution target in seconds and SLA percentage to view the result.

  5. Write a JQL as per requirement.

  6. Here, the user logged Time as 1h, 2h, and 3h for the respective issueissues, and Time to resolution is 16h. So the result is (1/16)*100=6.25 for the user spending 1h toward the goal of 16h

    image-20240219-070911-20240325-111042.pngImage Removed

    .

    image-20240219-070911-20240325-111042.pngImage Added

Info
  • Make changes in the JQL or fields as per specific requirements.