I have created a filter and used JQL to get the desired information,
issuetype = "Request a change" AND project = ISD AND updated >= 2020-03-05 AND updated <= 2020-04-14 AND assignee in (membersOf("IT Service Desk")) ORDER BY statusCategory ,status
The issue I have is with Order BY, it is doing the order by correctly for the status assigned to the statuscategory (from what I feel) with a status category for ToDo, but when the different category comes into play the order by plays up,
How does the Order by work. does it Order By StatusCategory first and then Status? And if this is the case, on what basis does the sorting happen?