Planning Level Iteration
The Planning Level Iteration dataset supports the Planning Level Iteration Analysis dashboard by providing insights into iteration-level data for planning levels. It captures information such as the total number of work items, completed and committed work items, removed items, and added work items. Additionally, it includes metrics to track lagging iterations and flags to indicate completed iterations. This dataset enables users to analyze the progress and performance of iterations within planning levels, offering a clear view of iteration dynamics and supporting effective planning and decision-making.
note
The data is filtered to include records where:
- The date difference (in months) between the adjusted end date and the data freshness date is within the specified month range.
- The date difference (in months) between the beginning date of the timebox now and the data freshness date is between 0 and 12 months.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Completed iteration flag | Flag to indicate the iteration status |
| Iteration | The iteration ID and name |
| Lagging count of months | The lagging count of months from the last ETL run date |
| Planning level | Name of the Planning Level |
| Sys_source | Source system identifier |
| Metric Name | Description |
|---|---|
| % WI Spillover | Percentage of work items that have spilled over to the next version of the project |
| Active Iterations | Count of active Sprints |
| Committed completed work items | Counts the number of work items committed at the start of the iteration and successfully completed |
| Committed work items | The number of work items committed in iteration |
| Completed work items | Completed work items count |
| Iteration count | The total number of iterations |
| Removed work items | Number of work items removed from the iteration |
| Scope change % | Percentage of the scope change associated with the iterations |
| Total added work items | Total number of work items added to the iteration |
| Total work items | The net count of work items in an iteration, calculated as the total added work items minus the removed work items |