問題

Jira Service Management reports show a spike at the end, simlar to what is seen in the following image:

原因

The report includes issues with SLAs that are still in running state. The SLA on these issues is used to calculate the last data point.

ソリューション

オプション 1

• Change the report so that issues with SLAs that are still running are not included in the report.

  • You can use JQL to exclude issues with SLAs that are still running.
    

    • For example, if your SLA is "Time to Resolution" you would want to exclude issues that are not resolved. You can do this using JQL "resolution is not empty". To achieve this: 

      1. Log into your Jira Service Management.
      2. Navigate to the affected Jira Service Management Project
      3. Click the "Reports" link in the menu on the left. If you can't see this menu, type: ']' (which will toggle this menu).
      4. Select the Report you want to modify, for example: "Time to resolution".
      5. Click the "Edit" button in the top right for the affected report.
      6. Click the "Edit" link for the affected series you would want to modify. This will bring up a dialogue.
      7. Modify the "JQL filter". If this is currently showing dropdown menu's, switch this to "Advanced" by selecting the link.
      8. Add: resolution is not empty to this JQL filter.
      9. Click Save in the dialogue, and then the Save button in the report page. The changes should be reflected immediately.

オプション 2

• Change the issues so that their SLA is no longer running
  
  • Jira Service Management will continue to include these issues when creating reports but now these issues will be included in the calculation for the day the SLA was stopped instead of being included in the calculation for the last data point
    • This means that you may see a spike on your chart the day that these SLAs are stopped.