Work item counts dataset
The work item counts dataset is a canonical-based dataset that offers a comprehensive view of work items within the system. It provides counts of various types of work items, including user stories, defects, tasks, and tests, across multiple planning levels or teams. This dataset enables you to analyze the volume of work items over time or by category, facilitating the tracking and managing workload, backlog, and project progress. Key metrics, such as the number of open, closed, and in-progress work items, are included to help monitor project health and team productivity.
note
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 |
| Work item | Unique identifier for the work item |
Metrics
| Metric Name | Description | Formula |
|---|---|---|
| Closed defects | The number of defects closed on the selected calendar date | Count(CASE WHEN closed_datetime IS NOT NULL and workitem_type = 'Defect' THEN workitem_idELSE null END) |
| Closed stories | The number of stories closed on the selected calendar date | Count(CASE WHEN closed_datetime IS NOT NULL and workitem_type = 'Story' THEN workitem_id ELSE nullEND) |
| Closed story points | The number of story points closed on the selected calendar date | Sum(CASE WHEN closed_datetime IS NOT NULL THEN story_points ELSE null END) |
| Closed test sets | The number of test sets closed on the selected calendar date | Count(CASE WHEN closed_datetime IS NOT NULL and workitem_type = 'TestSet' THEN workitem_id ELSE null END) |
| Closed work items | The number of work items that are closed on the selected calendar date | Count(CASE WHEN closed_datetime IS NOT NULL and workitem_type = 'Defect' THEN workitem_id ELSE nullEND) |
| Completed defects | The number of defects completed on the selected calendar date | Count(CASE WHEN completed_datetime IS NOT NULL and workitem_type = 'Defect' THEN workitem_id ELSE null END) |
| Completed stories | The number of stories completed on the selected calendar date | Count(CASE WHEN completed_datetime IS NOT NULL and workitem_type = 'Story' THEN workitem_id ELSE null END) |
| Completed story points | The number of story points completed on the selected calendar date | Sum(CASE WHEN completed_datetime IS NOT NULL THEN story_points ELSE null END) |
| Completed test sets | The number of test sets completed on the selected calendar date | Count(CASE WHEN completed_datetime IS NOT NULL and workitem_type = 'TestSet' THEN workitem_id ELSE null END) |
| Completed work items | The number of work items that are completed on the selected calendar date | Count(CASE WHEN completed_datetime IS NOT NULL THEN workitem_id ELSE null END) |
| Created defects | The number of defects created on the selected calendar date | Count(CASE WHEN workitem_type = 'Defect' THEN workitem_id ELSE null END) |
| Created stories | The number of stories created on the selected calendar date | Count(CASE WHEN workitem_type = 'Story' THEN workitem_id ELSE null END) |
| Created story points | The number of story points created on the selected calendar date | Sum( story_points) |
| Created test sets | The number of test sets created on the selected calendar date | Count(CASE workitem_type = 'TestSet' THEN workitem_id ELSE null END) |
| Created work items | The number of work items that are created on the selected calendar date | Count(workitem_id) |
| In progress defects | The number of defects currently in progress on the selected calendar date | Count(CASE WHEN inprogress_datetime IS NOT NULL and workitem_type = 'Defect' THEN workitem_id ELSE null END) |
| In progress stories | The number of stories currently in progress on the selected calendar date | Count(CASE WHEN inprogress_datetime IS NOT NULL and workitem_type = 'Story' THEN workitem_id ELSE null END) |
| In progress story points | The number of story points currently in progress on the selected calendar date | Sum(CASE WHEN inprogress_datetime IS NOT NULL THEN story_points ELSE null END) |
| In progress test sets | The number of test sets currently in progress on the selected calendar date | Count(CASE WHEN inprogress_datetime IS NOT NULL and workitem_type = 'TestSet' THEN workitem_id ELSE null END) |
| In progress work items | The number of work items currently in progress on the selected calendar date | Count(CASE WHEN inprogress_datetime IS NOT NULL THEN workitem_id ELSE null END) |