Work Item Iteration

The work item iteration dataset helps project managers track the iteration history of work items and analyze workload distribution. It provides insights into how many iterations a work item has been part of and the total number of work items assigned to an iteration. Teams can use this dataset to monitor iteration progress, optimize workload distribution, and generate reports to improve iteration planning and project execution.

note

The data is filtered to include only work items with freshness dates within the specified number of months. This ensures that only relevant and up-to-date data is considered based on the dataset retention policy.

The following are the components of this dataset:

Attribute Name	Description
Iteration	The iteration associated with the work item.
Iteration actual end datetime	The actual end date of the iteration (currently mapped to the completed date).
Iteration planned end datetime	The expected end date of the iteration (currently mapped to the end date).
Iteration start datetime	The start date of the iteration.
Portfolio item	The unique identifier for the portfolio item.
Work item	The unique identifier for the work item.
Work item completed by	The person who completed the work item.
Work item completed datetime	The date and time when the work item was completed.
Work item created by	The person who created the work item.
Work item created datetime	The date and time when the work item was created.
Work item planning level	The planning level associated with the work item.
Work item priority	The priority of the work item (list of values).
Work item status	The current status of the work item.
Work item team	The team assigned to the work item.
Sys_source	The unique identifier for the source system.

Metric Name	Description	Formula
Iteration count	The total number of unique iterations associated with work items.	Count(Iteration)
Work item count	The total number of unique work items associated to an iteration	Count(Workitem)