Work Item Snapshot Monthly
The Work item snapshot monthly dataset provides a comprehensive monthly summary of work item statuses and metrics. This dataset is essential for tracking overall progress, identifying trends, and ensuring alignment with long-term project goals and timelines. It includes key metrics such as the number of work items created, completed, and in progress, along with their distribution across different categories and teams. By delivering a detailed and timely snapshot of work item trends, this dataset helps teams maintain productivity, address potential issues proactively, and ensure effective project management.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar date | Gregorian calendar date displayed in the format 'M/D/YYYY' |
| Calendar month | Gregorian calendar month displayed in the format 'Mon YYYY' |
| Last refresh display date | Date of the most recent update or refresh of data in a dataset. It is in date, time, and time zone format. |
| Sys_source | Unique identifier for the source |
| Work item | Unique identifier for the work item |
| Work item backlog group | Backlog group of the work item |
| Work item iteration | Iteration of the work item |
| Work item planning level | Planning level of the work item |
| Work item portfolio item | Portfolio item of the work item |
| Work item priority | Priority of the work item |
| Work item state | Current state of the work item |
| Work item status source | Current status of the source work item |
| Work item team | Team of the work item |
| Work item type | Type of the work item |
| Metric Name | Description |
|---|---|
| Completed story points | The total story points are completed at the end of each iteration |
| Completed work items | The total amount of work items at the end of each iteration |
| Detail estimate hours | Summation of all estimate points of the backlog item in the iteration |
| Open story points | The total number of story points associated with work items that are currently in an "Open" or "To Do" state within a project or planning level |
| Open work items | The total number of work items that are currently in an "Open" or "To Do" state within a project or planning level |
| To do hours | Estimated time required to complete pending tasks associated with a work item |
| Total story points | Summation of story points associated with all work items within a planning level |
| Work item count | Count of work items in an iteration |