You are here:

Backlog Analysis

The Backlog Analysis dossier enables you to analyze backlog work items to understand average time taken for a work item to move from created to resolved, number of work items for each assignee, status of all created work items, average age of work items, and so on.

You can view the following reports from the Backlog Analysis dossier:

Issue Count by Project — Displays a count of created work items categorized by project and the average duration taken by work items to move from Created state to Resolved state.
Volume by Assignee — Displays the number of In Progress Work Items for each assignee.
Status — Provides an overall status of created work items by indicating if the work item is in progress or not.
Avg Age by Assignee — Displays the average age of a work item from Created state to Resolved state categorized based on assignee.
Aging — Displays the number of created work items over a monthly period.
Issue Type — Displays the average duration taken by work items to move from Created state to Resolved and Completed state, categorized based on the work item type.
Issue Details — Provides details about work items in a tabular format. You can view details such as Work Item Number, Summary, Assigned To, Work Item Type, and Avg Cycle Time.

Metrics Used

Metric Name	Description	Formula	Expected Value
Avg Cycle Time (Days)	Average number of days since the work item first moved to the IN PROGRESS until it is COMPLETED. If the work item is completed, the value is the difference between In Progress Date and the Completed Date else the value is the difference between In Progress Date and the current time	Age Since In Progress (in days)/ [Created work items - Proposed work items]	0 or >0
Avg Duration Created to Completed (Days)	Average number of days from the time the work item was created to it being completed. The value of this metric is blank if the work item is not yet completed	[Duration Created to Completed (days)] / [Completed Work Items]	>0, Closer to 0 is ideal
Avg Duration Created to Resolved (Days)	Average number of days from the time the work item was created to it being resolved. The value of this metric is blank if the work item is not yet resolved	[Duration Created to Resolved (days)] / [Resolved Work Items]	>0, Closer to 0 is ideal
Created Work Items	Count of all work items that are created.	Count [Work Items Created]	>=0
In Progress Work Items	Count of all work items whose current status category is "In Progress"	Count [Work Items In Progress]	>=0