Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-15106

Some reports are not showing the correct data if the workflow is changed.

      Summary

      Some reports (ie Velocity Report, Sprint Report) are not showing the correct data if the workflow is changed.

      Steps to reproduce

      1. Create a new Scrum project which will have 3 statuses (To Do, In Progress and Done)
      2. Create some issues, add some Story Points and create a new Sprint
      3. Add those issues in a Sprint and start it.
      4. Drag the issues to the right most column to complete it.
      5. Complete the Sprint
      6. Check on Velocity/Sprint report and data are showing correctly
        • Velocity report: Completed SP has some values in it
        • Sprint Report: Completed issues are in Done status
      7. Edit the workflow and remove Done status
      8. Add a new status in it (ie Resolved)
      9. Publish the workflow
      10. Go to the board's column configuration
      11. Drag Resolved status to the right most column
      12. Drag Done status to Unmapped column to remove it.
      13. Go back to the Report.

      Actual Result

      • Velocity Report: Completed SP is changed to 0
      • Sprint Report: All the previously completed issues that were in Done status, are now changed to the previous status (ie. To Do or In Progress).

      Expected Result

      • Velocity Report: Completed SP is still showing the old data.
      • Sprint Report: All completed issues are still with Done or Resolved status.

            [JSWSERVER-15106] Some reports are not showing the correct data if the workflow is changed.

            Beth Starr added a comment -

            I was able to replicate the issue and found the following:

            Old workflow statuses - To Do, In Progress, Closed

            New workflow statuses - Open, In Progress, Done

            All issues that were in Closed have a resolution and only the status changed to Done.

            If you remove Closed from the board column mapping, then it will no longer show completed issues in the Sprint Report or the Velocity charts, even though the items that were in Closed are now in Done status.  As long as Closed is in the Done column of the board, the reports will show completed issues in the Sprint Report and Velocity chart.  The theory of issues that contain a resolution are considered completed is simply not true with the reporting as the reports are looking at the status and not the resolution in my case.  A change in the status from Closed to Done breaks the reports for issues that were completed in the past.

            Beth Starr added a comment - I was able to replicate the issue and found the following: Old workflow statuses - To Do, In Progress, Closed New workflow statuses - Open, In Progress, Done All issues that were in Closed have a resolution and only the status changed to Done. If you remove Closed from the board column mapping, then it will no longer show completed issues in the Sprint Report or the Velocity charts, even though the items that were in Closed are now in Done status.  As long as Closed is in the Done column of the board, the reports will show completed issues in the Sprint Report and Velocity chart.  The theory of issues that contain a resolution are considered completed is simply not true with the reporting as the reports are looking at the status and not the resolution in my case.  A change in the status from Closed to Done breaks the reports for issues that were completed in the past.

            This issue can be split into two parts:

            • Velocity Chart - charts are working based on current board configuration. If the current board configuration does not include the "Done" state in the "Done" column, issues in that status are not considered completed. This is why the Velocity Chart is showing zero as the amount of completed work. This wotks as intended.
            • Sprint Report - when it comes to completed issues, the situation is identical as with the Velocity Chart. If an issue is not in a status that is currently mapped to the "Done" column, it will not be considered as completed. However, when a status that the issue is in is not mapped to any column on the board, its status is shown as "To Do", which is incorrect. This will be corrected as part of this ticket.

            Kind regards,
            The JIRA Software Team

            Marek Broda (Inactive) added a comment - This issue can be split into two parts: Velocity Chart - charts are working based on current board configuration. If the current board configuration does not include the "Done" state in the "Done" column, issues in that status are not considered completed. This is why the Velocity Chart is showing zero as the amount of completed work. This wotks as intended. Sprint Report - when it comes to completed issues, the situation is identical as with the Velocity Chart. If an issue is not in a status that is currently mapped to the "Done" column, it will not be considered as completed. However, when a status that the issue is in is not mapped to any column on the board, its status is shown as "To Do", which is incorrect. This will be corrected as part of this ticket. Kind regards, The JIRA Software Team

              Unassigned Unassigned
              rsaputra Adven
              Affected customers:
              5 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated: