Work Item Snapshot Weekly
The Work item snapshot weekly dataset provides a detailed weekly summary of work item statuses and metrics. This dataset is crucial for tracking progress, identifying bottlenecks, and ensuring alignment with project timelines and objectives. It includes key metrics such as the number of work items created, completed, and in progress, as well as the distribution of work items across different categories and teams. By offering a comprehensive and timely snapshot of work item trends, this dataset aids teams in maintaining productivity and ensuring effective project management.
note
The data is filtered to include only the snapshot dates from the last 24 weeks.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar date | Gregorian calendar date displayed in the format 'M/D/YYYY' |
| Calendar week | Gregorian calendar week displaying the week number. For example, |
| W21, W22. | |
| 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 |