Purpose
To calculate the average number of budgeted hours assigned to all currently open (incomplete) tasks, helping managers understand the typical workload per task and plan staffing or timelines accordingly.
Visualization Type | KPI |
Liveboard | Capacity Dashboard |
Tab | Tasks |
Function | Capacity |
| Includes Excludes |
Need-to-know Glossary of Terms
Task Status - Designation that indicates the current state of a task (e.g. in progress, with client, completed).
Average Task Budgeted Hours - Average total hours budgeted to a task (this is done by adding the keyword average before the data point Task Budgeted Hours).
Report Structure Overview
Task Budgeted Hours filter - Filtered to include tasks with more than O budgeted hours.
Task Status filter - Filtered to exclude completed tasks
KPI Value - Average Open Task 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, and Task 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 tasks 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 task scoping or forecasting.