Purpose
To calculate the average number of budgeted hours assigned to all currently open (incomplete) subtasks, helping managers understand the typical workload per subtask and plan staffing or timelines accordingly.
Visualization Type | KPI |
Liveboard | Capacity Dashboard |
Tab | Subtasks |
Function | Capacity |
| Includes Excludes |
Need-to-know Glossary of Terms
Subtask Budgeted Hours - Total hours budgeted to a subtask.
Subtask Status - Current state of a subtask within a workflow (e.g. not started, in progress, with client, completed, etc.).
average Subtask Budgeted Hours - keyword operator ‘average’ which finds the average of the budgeted hours for all subtasks not yet completed.
Report Structure Overview
Subtask Budgeted Hours filter - Filtered to include subtasks with more than O budgeted hours
Subtask Status filter - Filtered to exclude completed subtasks
KPI Value - Average Open Subtask Budgeted Hours
Suggested Modifications
Want to understand the underlying data making up this KPI?
1. Hover over the KPI and select the ellipses button on the top right corner.
2. Select Show Underlying Data.
3. Click the Edit Columns button in the top right corner.
4. Add the data points Client Name, Task Name, Subtask Name, and Subtask Assignee by either typing it in the search bar or selecting the checkbox next to the name.
5. Press Done.
Primary Use Case Scenario
A Team Lead reviews this KPI weekly to evaluate whether open subtasks are appropriately scoped in terms of estimated effort and balance team assignments by understanding the average size of pending work.
Actionable Insights
Visibility into the average effort remaining per task, useful for capacity and resource planning and early insight into possible inefficiencies in subtask scoping or forecasting.