Defect Base
The Defect Base dataset is a comprehensive collection of data points detailing defect-related activities within a project. This dataset is crucial for tracking defect progress, monitoring details, and ensuring software quality and functionality. By providing a complete view of reported defects in the Agile project environment, it enables teams to analyze defect patterns, improve quality control, reduce defect leakage, and refine Agile processes. Leveraging this data empowers teams to make informed, data-driven decisions that enhance software quality, support effective collaboration, and contribute to overall project success.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Defect | Unique identifier for the defect |
| Defect completed by | The person who marked the defect as completed |
| Defect completed date time | The date time when the defect is marked as completed |
| Defect created by | The person who created the defect in the system |
| Defect created date time | The date time when the defect is created initially |
| Defect detected build | The defect detected in build number |
| Defect fixed build | The build number when the defect is marked as fixed |
| Defect inprogress date time | The date time when the defect is moved to In progress status |
| Defect iteration | The iteration to which the defect is linked to |
| Defect name | The short description of the defect tittle |
| Defect planning level | The planning level to which the defect is associated with |
| Defect portfolio item | The portfolio item to which the defect is linked to |
| Defect reopened date time | The date time when the defect was reopened |
| Defect reopened flag | The flag defines whether the defect is reopened |
| Defect resolution | The resolution provided to the defect like Fixed, Rejected or Cannot Reproduce |
| Defect source url | Defect source system url |
| Defect status | Status of defect like In progress, Not Started, Done, Completed, Closed |
| Defect status category | The status category that corresponds to the current status of the defect |
| Defect team | The team name to which the defect is linked to |
| Defect type | The type of the defect whether it's Release, Pro-Release, and Documentation |
| Defect updated by | The person who last updated the defect |
| Defect updated date time | The date time when the defect is last updated on |
| Sys_source | Source system identifier |
| Metric Name | Description | Formula |
|---|---|---|
| % Accepted | The percentage of reported defects successfully resolved. It reflects defect management efficiency. | ([Fixed defects]/[Reported defects]) |
| % Deferred | The percentage of reported defects postponed for future resolution. It indicates prioritization decisions. | ([Defered defects]/[Reported defects]) |
| % Rejected | The percentage of reported defects that were rejected. It indicates invalid or non-actionable defect submissions. | ([Rejected defects]/[Reported defects]) |
| Average defect age in days | The average time defects remain open. It provides insight into defect resolution efficiency. | [Defect age in days]/[Reported defects] |
| Defect age | The time taken for the defect since creation to closed state for closed defects, and time since creation for open defects. | Defect resolved date - Defect created date |
| Defect age in days | Duration between defect created date and completed date time in days | Age Since Creation / 86400.0 |
| Defect gap % | The proportion of open defects relative to the total reported defects. It highlights unresolved issues. | [Open defects]/[Reported defects] |
| Deferred defects | The count of defects resolved as "Cannot Reproduce," "Duplicate," or "As Designed." | Count(Deferred defects) |
| Fixed defects | It counts the number of defects resolved with the status "Fixed." | Count(Fixed defects) |
| Open defects | It counts defects that are not marked as "Completed," indicating unresolved issues. | Count(Open defects) |
| Rejected defects | It counts the number of defects resolved with the status "Rejected." | Count(Rejected defects) |
| Reopen ratio | It calculates the proportion of defects that were reopened after being fixed and indicates the effectiveness of the defect resolution process. | ([Reopened defects]/[Fixed defects]) |
| Reopened defect age in days | It calculates the total age, in days, of defects that are reopened and provides insight into the duration of issues after being marked as resolved. | Sum(Reopened defect age in days) |
| Reopened defects | It counts the number of defects that were reopened after being initially resolved. | Count(Reopened defects) |
| Reported defects | It counts the total number of distinct defects that are reported. | Count(Reported defects) |