Skip to main content

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.

The following are the components of this dataset:

Attribute NameDescription
Calendar dateGregorian calendar date displayed in the format 'M/D/YYYY'
Calendar weekGregorian calendar week displaying the week number. For example,
W21, W22.
Last refresh display dateDate of the most recent update or refresh of data in a dataset. It is in date, time, and time zone format.
Sys_sourceUnique identifier for the source
Work itemUnique identifier for the work item
Work item backlog groupBacklog group of the work item
Work item iterationIteration of the work item
Work item planning levelPlanning level of the work item
Work item portfolio itemPortfolio item of the work item
Work item priorityPriority of the work item
Work item stateCurrent state of the work item
Work item status sourceCurrent status of the source work item
Work item teamTeam of the work item
Work item typeType of the work item
Metric NameDescription
Completed story pointsThe total story points completed at the end of each iteration.
Completed work itemsThe total number of work items completed at the end of each iteration.
Detail estimate hoursSummation of all estimate points of the backlog item in the iteration.
Open story pointsThe total number of story points associated with work items that are currently "Open" or "To Do."
Open work itemsThe total number of work items that are currently "Open" or "To Do."
To do hoursEstimated time required to complete pending tasks associated with a work item.
Total story pointsSummation of story points associated with all work items within a planning level.
Work item countCount of work items in an iteration.