...
Navigate to Apps and select Reports and Timesheets.
Navigate to My Area and select the My Calculate field. Click on Create New Field.
Create a Calculated field to convert Time to resolution target in seconds because it shows in milliseconds in reports. We have converted this to seconds, and the Time spent field is in seconds, so the values should match to calculate the percentage in seconds.
...
Navigate to Apps and select Reports and Timesheets.
Navigate to New Report and select Custom Reports.
Select view type as List.
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.
Write a JQL as per requirement.
Here, the user logged Time as 1h, 2h, and 3h for the respective issue, 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.
| Info |
|---|
Make changes in JQL or fields as per specific requirements. |