Work Item Snapshot Daily
The Work item snapshot daily dataset contains daily snapshots or snapshots at regular intervals of various attributes or metrics related to work items at a project or planning level. The dataset may be used for various purposes, including performance analysis, process improvement, capacity planning, forecasting, and reporting. This dataset provides you valuable insights into the dynamics of work item management and helps optimize project workflows and resource allocation.
note
The data is filtered to include only the snapshot dates from the last 30 days.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar date | Gregorian calendar date displayed in the format 'M/D/YYYY' |
| Last refresh date | Date of the most recent update or refresh of data in a dataset. It is in date format. |
| 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 |
|---|---|
| Blocked backlog item count | Count of blocked backlog items |
| 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 |