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 completed at the end of each iteration.
Completed work items	The total number of work items completed 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 "Open" or "To Do."
Open work items	The total number of work items that are currently "Open" or "To Do."
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.