Work Item Status Change

The work item status change dataset allows you to generate ad hoc reports that analyze the progression of work items through various states and the time spent in each state. It helps track status transitions, sequence changes, and lifecycle durations, providing insights into workflow efficiency. This dataset supports identifying trends, monitoring work item progress, and improving process optimization.

note

The data is filtered to include only work items with status changes and portfolio items closed 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	Portfolio item linked to the work item
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.
Work item	Unqiue identifier for the work item
Work item backlog group	The name of the backlog group to which the work item is assigned.
Work item closed by	Person who closed the work item
Work item closed datetime	Date and time when the work item was closed
Work item created by	Person who created the work item
Work item created datetime	Date on which the work item was created
Work item planning level	The planning level associated with the work item.
Work item source URL	URL linking the work item to the source
Work item state	The work item state that indicates whether the work item is active or inactive.
Work item status	Current status of the work item
Work item team	Team working on the work item
Workitem title	Short description of the work item
Work item type	Type of the work item
Sys_source	Source system identifier

Metric Name	Description	Formula
Average status change count	The average number of times a portfolio item changes status.	[New status change count] / Count(Workitem)
Average status duration days	The average number of days a portfolio item spends in a particular status.	[New metric] / Sum[Incomplete workitems]
Max duration for status days	The maximum number of days a portfolio item has spent in a particular status.	Max[New metric]
Max status change sequence internal	Latest status update for each work item	Max([Status change sequence])(Workitem)
Min duration for status days	It picks the smallest [New Metric] value, but only for work items that are still open (i.e., not yet moved to a completed status).	Min [New Metric] (open/incomplete work items)
Status change count	The total number of times a portfolio item changes status.	Sum(Completed workitems)
Status duration	The total duration a portfolio item spends in a particular status.	Workitem status duration
Status duration days	The number of days a portfolio item spends in a specific status.	Sum([Status duration days])