Work item canonical
The work item canonical dataset provides a unified view of work items across the system, capturing their lifecycle, status, and associations with planning levels and portfolio items. It enables tracking work item creation, completion, and progress while ensuring alignment with organizational planning structures. This dataset supports in-depth analysis of work item trends, backlog management, and decision-making in project and portfolio management.
The data is filtered to include only active work items with valid portfolio items. It considers records where either both audit end values in the work item super hierarchy and scope parent hierarchy are null or where the date difference (in months) between the adjusted end date and the data freshness date falls within the specified range.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar Date | Gregorian calendar date displayed in the format 'M/D/YYYY' |
| Created datetime | The timestamp when the work item was created. |
| Sys_source | Source system identifier |
| Workitem | Unique identifier of the work item |
| Workitem planning level | Planning level associated to the work item |
| Workitem planning level URL | URL of the planning level to which the work item is linked |
| Workitem portfolio item | The portfolio item linked to a work item, indicating its hierarchical association within the planning structure. |
| Workitem status | Current status of the work item |
| Workitem status category | Current state category of the work item |
| Workitem type | Type of work item. For example, Defect, Story, Test set |
| Metric Name | Description |
|---|---|
| % Backlog | The percentage of work items still pending completion within the backlog. |
| % Work item completed | Percentage of work items that are in the completed state. |
| All WIs - cumulative | The cumulative total of all created work items over time. |
| Completed WI - cumulative | The cumulative total of all completed work items over time. |
| Completed work items | Completed work items count. |
| Created work items | Created work items count. |
| Pattern | A progress bar representation of work item completion based on the percentage completed. |