Test counts dataset
The test counts dataset is a canonical-based dataset that offers a comprehensive view of test-related activities within the system. It captures the counts of various test types, including manual, automated, and exploratory tests, across multiple planning levels or teams. This dataset helps monitor testing progress by tracking the number of tests that have passed, failed, are in progress, or have not been executed. By providing insights into test coverage and execution status, it plays a crucial role in assessing product quality, identifying bottlenecks, and ensuring that testing efforts stay aligned with project timelines and objectives.
This dataset's metrics cannot be combined with metrics from other datasets. It is intended for use in date-based analysis only.
The following are the components of this dataset:
Attributes
| Attribute Name | Description |
|---|---|
| Calendar date | Canonical calendar date attribute |
| Sys_source | Unique identifier for the source |
| Test | Unique identifier for the test |
Metrics
| Metric Name | Description | Formula |
|---|---|---|
| Closed tests | The number of tests closed on the selected calendar date | count(case when closed datetime is not null then test_id else null end) |
| Completed tests | The number of tests completed on the selected calendar date | count(case when completed datetime is not null then test_id else null end) |
| Created tests | The number of tests created on the selected calendar date | count(test_id) |
| In progress tests | The number of tests currently in progress on the selected calendar date | count(case when inprogress datetime is not null then test_id else null end) |