Have you ever had situations where you need to know when and what changes have occurred with tasks in Jira? Need to view the tasks’ archive change log in the project or for a specific user? If so, this article will come in handy.
Experienced Jira users know that everyone can see the information for each task with the built-in History Tab. But this method in practice is often inconvenient because it requires a lot of manual work to analyze the list of tasks that interest you.
You can solve this problem with the Issue History add-on. It allows you to see all the changes that have been made to the issue automatically and in one place. Thus, by installing the application today, you will have access to archive data of all changes in your Jira issues.
Jira’s users are often interested in how they can monitor status changes for their Jira tasks. Such as by whom and when a task has been moved from one status to another. To show how to separate this information from other changes, we have decided to write instructions on how to do it.
First, you can see this data on the application grid. To do this, you need to select the ones that will allow you to see the changes in the columns in the column settings menu. Namely:
- Issue Key
If you need to filter the list of tasks by project, assignee, specific filter, you can use the “Selected by” functionality. If you want to filter tasks by the one who has moved it from one status to another, use the “Updated by” functionality and select the assignee you are interested in.
Another convenient way to analyze data is to use Issue History exported data and analysis by Pivot Table feature of Google Spreadsheet.
All you need is to do the next steps:
1. Export data from the Issue History app installed on your Jira. In this case, you can select any fields (assignee, comments, etc.) in the Column Manager, including Issue Key, Status, and Summary.
2. Open a document with the Google Sheets – Select Pivot table in the Data section.
3. Select Rows in such order: Issue Key- Issue URL – Summary – Date – Status (old) – Status (new) – Updated by
4. When selecting each row, exclude Total one.
5. Select Status (old) in the Filter section – uncheck Blancs.
6. If necessary, you can filter the data by any field you need (updated by, issue key, assignee, etc.)
As the result, you will get data that shows you the dates and time of exit and entry in each status.
In addition to analyzing status changes, you can also analyze assignee and priorities changes, add comments to tasks, and much more. To do this, you need to select another column in the rows instead of statuses.