Portfolio Item Status Change
The portfolio item status change dataset allows you to create ad hoc reports that track the progression of portfolio items through various statuses and the duration spent in each status. It provides insights into the portfolio's health, associated risks, status transitions, and the planning levels of the items. This dataset helps in analyzing the timing of status changes, understanding team involvement, and managing the overall portfolio efficiently by monitoring the time spent in each status.
note
The data is filtered to include only portfolio items with status changes within the specified timeframe, ensuring freshness and relevance.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| End datetime | The date and time until the portfolio item remained in a specific status. |
| Portfolio item | Unique identifier for the Portfolio item |
| Portfolio item closed by | Person who closed the portfolio item |
| Portfolio item closed date time | Date and time when the portfolio item was closed |
| Portfolio item created by | Person who created the portfolio item |
| Portfolio item created datetime | Date and time when the portfolio item was created |
| Portfolio item planning level | Planning level associated to the portfolio item |
| Portfolio item source URL | URL linking the portfolio item to the source |
| Portfolio item state | Portfolio item state that indicates whether the portfolio item is active or inactive |
| Portfolio item status | Current status of the portfolio item |
| Portfolio item target team | Team that is working on the portfolio item |
| Portfolio item title | Short description of the portfolio item |
| Portfolio item type | The type of portfolio item, such as epic, feature, or initiative. |
| Start datetime | The first date and time when the portfolio item entered a specific status. |
| Status category | The status category associated with the current status of the portfolio item. |
| Status change sequence | A unique sequence number assigned to each status change. |
| Status from | The status for which the status duration is being calculated. |
| Status to | The status to which the portfolio item transitioned from its current status. |
| Sys_source | Source system identifier |
| Metric Name | Description | Formula |
|---|---|---|
| Average status change count | The average number of times a portfolio item changes status. | [Status Change Count] / Count (Portfolio item) |
| Average status duration days | The average number of days a portfolio item spends in a particular status. | [Status duration days] / Sum (completed status category + Max status change sequence) |
| Max duration for status days | The maximum number of days a portfolio item has spent in a particular status. | Max([Status duration days]) |
| Max status change sequence internal | The highest sequence number assigned to a status change for a portfolio item. | Max([Status change sequence]) BY [Portfolio item] |
| Min duration for status days | The minimum number of days a portfolio item has spent in a particular status. | Min([Status duration days]) |
| Status change count | The total number of times a portfolio item changes status. | Sum(Max status change sequence) |
| Status duration | The total duration a portfolio item spends in a particular status. | Sum([State duration]) |
| Status duration days | The number of days a portfolio item spends in a specific status. | [Status duration]/86400 |