Update Insights Logic where 'Done' is based on a status category or workflow

Problem Definition

Insights in a sprint's board shows completed issues as not yet Done if the Done status is not in the last (rightmost) column on the board.

Jira business logic defines issues that are in the last column as complete. Any issues that aren’t in the last column on the board will be considered incomplete, irrespective of the status category mapped to that column.

Currently, we can edit the workflow to add multiple statuses in the Done category but Jira doesn't use this category to calculate the Done status in the Insights data. Instead, it calculates the rightmost column as Done.

Suggested Solution

Update Jira's Insights logic where ‘Done’ is based on a status category or workflow and not column position.

Why this is important

Users with workflows that do not have ‘Done’ or ‘Done’ mapped to the last column will not be able to use reports for insights.

Workaround

To mitigate any problems, try this workaround:

1. Go to Board > Manage workflow.
2. Add the removed Done status to your workflow. Give the status the same name as previously used in your workflow and reports.
3. At this stage, avoid adding any incoming transitions.
4. Save and publish the workflow.
5. From your board, navigate to the More actions (•••) > Board settings.
6. In Columns and statuses, move the Done status to the rightmost column.
7. Hit save.
8. Your reports should behave as before. Add any incoming transitions to the status.

 h3. Other Notes
This is very similar to JSWCLOUD-15106 except that this one is specific to Insights functionality in the board, while JSWCLOUD-15106 is focusing on the reports logic.