Tickets changed to a status by a user over a time period

[Timothy Daniels]

Hi all,

Hoping if someone might have some idea on how to generate a report on how many tickets have changed to a status by a particular user over a time period. 

For example, 65 tickets were changed to status = 'Done' by 'John Smith', 78 tickets were changed to status = 'Done' by 'Joan Smith'. 

If there is some type of bar graph view or export to CSV function that would be great to know. 

[Steven de Groot]

Hi Timothy,

I believe you are looking for the "status CHANGED FROM" and "DURING" JQL functions. This will allow you to list issues that were changed from 1 step in the workflow to another. 

Example:

project = DRX and status CHANGED FROM 'In progress' to 'Done' BY Charlie DURING (startOfMonth(), endOfMonth()) 

You could use this type of JQL under Issues -> Current Search and then click on the export button. 

Here are some nice articles about advanced JQL queries:

• https://confluence.atlassian.com/jiracorecloud/advanced-searching-765593707.html
• https://www.atlassian.com/blog/jira-software/jql-recap

Regards,

Steven

[Timothy Daniels]

Hi Steven, thank you so much for your help. I'm having a look now and if for instance I wanted to look at multiple users in the same JQL and then export the results to a CSV, is it possible to add a column which would be something like 'Marked as Done By'.

project = DRX and status CHANGED FROM 'In progress' to 'Done' BY (Charlie,Tim,Jason) DURING (startOfMonth(), endOfMonth())  

For each of the issues on the export I could pull together the data on how many issues Charlie, Tim and Jason have marked as Done. 

[Steven de Groot]

Hey Timothy,

If you have this column as a custom field, you can switch to list view and add it via the "Columns" drop down button.

Regards,

Steven