Is there any way to use pivot analysis?
Answer
The pivot analysis tool can easily aggregate and graph recorded review comments.
Below is an example of how to use the pivot analysis tool.
Check the number and removal rate of defects within a process
Set the detection process and cause process fields in the row area and column area respectively.
You can check the process and number of cases where external specification defects were detected as shown in the figure below.
You can see that it was detected in the following processes.
| Detection process | Number of cases |
|---|---|
| Usability implementation DR | 1 case |
| External specification DR | 26 cases |
| CR | 5 cases |
Check the process where a serious defect was mixed in
Set the cause process and type fields in the row area and the severity field in the column area.
In the figure, you can see that many high-severity defects were mixed in the external specification process.
You can take action to improve the results of this analysis.
Example) Check the process implementation status of the external specification creator.
Check the status of issues addressed in review files
Set the review file name in the row area and the status field in the column area.
You can check the trend of issues for each review as shown in the image.
Example: How many issues are open, fixed, and confirmed?
Unlike Review Explorer, it is convenient because you can include any file as a target.