Work Item Backlog
The Work Item Backlog dataset provides a comprehensive view of work items to support backlog management and project tracking. It helps teams monitor task progress, prioritize work, and analyze performance metrics such as iteration cycles and time-to-completion. The dataset captures planning details, status, priority, ownership, and team information, fostering collaboration and accountability. With clear summaries and status categories, it enables teams to align tasks with project goals, identify bottlenecks, and improve sprint planning and resource allocation.
The data is filtered to include only records where the rollup state and state ID are less than 128, and the date difference from the end date to the data freshness date is within the specified month range.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Action | The set of actions needed for work items |
| Sys_source | Source system identifier |
| Work item | The work item identifier or name |
| Work item iteration | The iteration to which the work item belongs |
| Work item planning level | The planning level of the work item |
| Work item priority | Priority of the work item |
| Work item source URL | URL for the source system of the work item |
| Work item status category | Current state category of the work item |
| Work item summary | A description of the work item |
| Work item team | Team linked to the work item |
| Work item type | The type of the work item |
| Metric Name | Description | Formula |
|---|---|---|
| Days since last update | The difference between last updated date and the current date in seconds | Difference in seconds/86400 |
| Duration since last update seconds | The difference between last updated date and the current date in seconds | Duration since last update / 86400 |
| Iteration count | Distinct count of the iteration to the work item it is linked to | Count(Iteration) |