Testset
The Testset dataset provides detailed insights into test sets, enabling teams to monitor their creation, status, progress, and completion. It consolidates data related to ownership, planning levels, priority, and performance metrics, such as lead time, cycle time, and time spent. This dataset helps Agile teams, Test Managers, and Quality Assurance teams track testing workflows, evaluate resource utilization, and optimize delivery timelines.
note
The data is filtered to include only 'TestSet' assets with freshness dates within the specified number of months, ensuring that only relevant and up-to-date data is considered.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Last refresh date | Last ETL refresh date |
| sys_source | Source system identifier |
| Testset | Unique identifier of the testset |
| Testset backlog group | The backlog group to which the testset belongs |
| Testset category type | Category type from which the testset originated |
| Testset class of service | Class of service value associated with the testset |
| Testset closed by | Person who completed the testset |
| Testset closed datetime | The date when the testset was closed |
| Testset completed by | Person who completed the testset |
| Testset completed datetime | Date and time when the testset was completed |
| Testset created by | Person who created the testset |
| Testset created datetime | Date and time when the testset was created |
| Testset in progress datetime | Earliest date when the testset was marked as in progress |
| Testset iteration | The iteration to which the testset is linked |
| Testset last iteration end datetime | Planned end date and time of the last iteration linked to the testset |
| Testset last iteration start datetime | Actual start date and time of the last iteration linked to the testset |
| Testset last update datetime | Date and time when the testset was last updated |
| Testset last updated by | Person who last updated the testset |
| Testset linked to portfolio flag | Flag to indicate if the testset is linked to a portfolio item |
| Testset not started flag | Flag to indicate whether the testset has not started |
| Testset original completed by | Person who originally completed the testset |
| Testset original completed datetime | Date and time when the testset was originally completed |
| Testset planning level | The planning level to which the testset belongs |
| Testset portfolio item | Portfolio item to which the testset is associated |
| Testset priority | Priority of the testset |
| Testset reopened by | The user who reopened the testset |
| Testset reopened datetime | Date and time when the testset was reopened |
| Testset source URL | Testset source system URL |
| Testset split from | Workitem from which the testset was split |
| Testset state | Current state of the testset |
| Testset status | Status of the testset |
| Testset status category | Current state category of the testset |
| Testset summary | The description or summary of the testset |
| Testset team | Team that is linked to the testset |
| Testset type | The type of work item represented by the testset |
| Metric Name | Description | Formula |
|---|---|---|
| Story points | Story points assigned to the testset | Story_points |
| Testset age since creation in days | Age since the testset was created | (Closed datetime - Created datetime) / 86400 |
| Testset cycle time in days | Duration between when the testset started and when it was closed | (Completed datetime - Created datetime) / 86400 |
| Testset detail estimate hours | Detail estimate of the time required to complete the testset | Detail estimate hours/8 |
| Testset duration created to in progress | Time duration between testset creation and in progress | (Work start datetime - Created datetime) / 86400 |
| Testset lead time in days | Duration between the creation of the testset and its completion | (Completed datetime - Created datetime) / 86400 |
| Testset timespent in days | Total amount of time spent on the testset | Time spent/8 |
| Testset to do hours in days | Total amount of time spent on to-do activities for the testset | To do hours/8 |