You are here:

Release Task Open Work Analysis

The Release Task Open Work Analysis dashboard provides a detailed view of open release tasks and the trend of upcoming release tasks. You can also view the tasks that are contributing to delays in the release and take necessary actions. With these insights, you can gauge the current standing of the task progress, along with the overall status of release tasks at different stages of the release, and can be better prepared for the upcoming release tasks.

As a Release Owner, you can use this dashboard to understand the following business scenarios:

What is the overall status of a Release task and its associated Release tasks at different stages or types?
What are the open or pending tasks, and which of these tasks require immediate attention?
What are all the upcoming tasks, and is there any dependency that causes a delay, or any prioritization required?

This dashboard enables you to perform detailed analysis on the current release tasks that are open, and identify areas to focus on, to improve the overall release progress. Additionally, you can view detailed information about upcoming release tasks and ensure that there are no impediments to release.

The Release Task Open Work Analysis dashboard is built using the Release Tag, Release Task Tag, and Release Task iCubes and fetches data based on the filter specified for these iCubes.

You can use the filter in the dashboard to analyze information related to specific Release Folder and Release Owner. The dashboard supports a single level of hierarchy in case of filtering results based on Folders.

Note: The values of KPIs changes according to the selected filter such as Release Folder or Release Owner.

The Release Task Open Work Analysis dashboard consists of the following sections:

KPIs

No of Open Release Tasks: Displays the total number of Release tasks whose status are either In Progress, Failed, or Planned.
No of Upcoming Release Tasks: Displays the total number of Release tasks in Planned status for the next 12 months.
No of In Progress Release Tasks: Displays the total number of Release tasks whose status is In Progress.
No of Completed Release Tasks: Displays the total number of Release tasks that are completed in the last 30 days.
% Completed Release Tasks: Displays the percentage of Completed Release tasks for the release in the last 30 days.
% Late Release Tasks Open and Completed: Displays the percentage of Release tasks that are late among all the open and completed tasks in the last 30 days.

The page-level filters in the dashboard enable you to drill down further using specific Release Name, Release Tag, Release Start and End Date, Release Task Type, Task Start and End Date, and Release Task Tag.

Note: The page-level filters have no impact on KPI values and act only on the grids available on the page.

In Progress Tasks

This panel provides detailed information about the In Progress release tasks. You can use the page level filters in the dashboard as per your requirement to populate the data in this grid. You can find the details such as Task Name, Phase Name, Release Names, Task Type, Release Risk Score, and the remaining time left to complete the specific release task.

You can also click the Link to the Source System icon against a specific task name to launch the source system and view more details about the work items.

Task trend for next 15 days

Displays a line graph that provides the trend of release tasks for the next 15 days of the planned start date. The X-axis represents the calendar date and the Y-axis represents the count of upcoming release tasks.

You can hover over the line graph to get details of the number of upcoming release tasks on a specific date.

Tasks starting in the next N hours

Displays a grid that provides information about the tasks beginning in the next N hours depending on further filter selection in the grid. The default value for N is 3 hours. You can view the number of hours remaining until the projected planned start date or planned start date of the release task. With these forecasted insights of release tasks, you can foresee the dependencies and organize accordingly.

Note: N hours can be modified to suit your business requirement. You must always choose the "Less than or equal to" option while entering the desired N hours.

You can also click the Link to the Source System icon against a task name to launch the source system and view more details about the upcoming release tasks.

Late Tasks

This panel provides detailed information about the late release tasks that are In Progress, Failed, or Completed status along with the tasks that are planned for the upcoming release. The tasks that are In Progress status are considered late when the current date is more than the project end date, or the projected end date is greater than the planned end date. The upcoming release tasks are considered late when the projected start date is greater than the planned start date. The data in this grid is driven by the filter selection in the dashboard.

You can also click the Link to the Source System icon against a task name to launch the source system and view more details about the late release tasks.

Objects used in this dashboard

This section lists all the attributes and metrics used to build the reports in this dashboard.

Attributes

Attribute Name	Description
Task Name	Title of a Release Task.
Phase Name	Title of a Release Phase.
Release Name	Title of a Release.
Task Type	Task Type denotes the task that requires user actions, automated tasks, and tasks that serve as containers to group other types of tasks.
Task Projected End Date	The date on which the release task is scheduled to end.
Release Owner	The owner of the release.
Team	The name of the team this specific task is assigned to.
Projected Planned Start Date	The date on which the release task is scheduled to start and is calculated based on the specified duration.
Planned Start Date	The date on which the release task is scheduled to start.
Status	The current status of the release task.
Projected Planned End Date	The date on which the release task is supposed to end. It is calculated projected dates using the duration specified.
Planned End Date	The date on which the release task is scheduled to end.
Actual Start Date	The date when the release task is actually started.
Risk Score	Risk Score for a release.

Metrics

Metric Name	Description	Metric Formula
Time To Close Release Task(Hours)	Time duration left until the task was initially planned to close (projected planned end date or planned end date of release task (in hours)).	NullToZero(([Time To Close Release Task] / 3600.0))
Hours Until Task Start	Time duration left until projected planned start date or planned start date of release task (in hours).	NullToZero(([Time To Start Release Task] / 3600.0))
No of Open Release Tasks	Total no of tasks that are either in progress, failed or planned in the release.	Count([No of Release Tasks])<[Open Release Tasks]>
No of Upcoming Release Tasks - Next 12 Months	Count of release tasks that are in planned status and planned date is in future 12 months.	Count([No of Release Tasks])<[Release Task Upcoming 12 Months]>
No of In Progress Release Tasks	Count of Tasks that are in In Progress status.	Count([No of Release Tasks]) <[Release Task Status = IN_PROGRESS]>
No of Completed Release Tasks - Last 30 days	Count of Tasks that are completed.	Count([No of Completed Release Tasks])
% Completed Release Tasks - Last 30 Days	Percentage of tasks that are completed.	NullToZero(([No of Completed Release Tasks] / [No of Release Tasks]))
% Late Release Tasks Open and Completed	% of tasks which are late among all the open and last 30 days completed tasks.	NullToZero((([No of Late Open Release Tasks] + [No of Late Completed Release Tasks - Last 30 Days]) / ([No of Open Release Tasks] + [No of Completed Release Tasks - Last 30 Days])))