Purpose
To visualize the trend of open tasks over time based on their due dates, helping managers anticipate workload peaks, track completion progress, and prepare for upcoming deadlines.
Visualization Type | Line chart |
Liveboard | Capacity Dashboard |
Tab | Tasks |
Function | Capacity |
| Includes Excludes |
Need-to-know Glossary of Terms
Task Count - Number of tasks.
Task Status - Designation that indicates the current state of a task (e.g. in progress, with client, completed).
Task Assignee - Team Member assigned to the task.
Task Due Date - Date a task is due.
Overdue Tasks Formula - Denotes any task that has a due date prior to current day as ‘overdue’ and tasks with a due date after the current day as ‘not overdue’.
if ( Task Due Date < today ( ) ) then 'Overdue' else 'Not Overdue'
Report Structure Overview
Task Status filter - Filtered to exclude completed tasks
Task Due Date filter - Filtered to capture the previous 30 days and next 30 days
Y~ Axis - Task Count
X ~ Axis - Task Due Date daily
Legend - Not Overdue and Overdue tasks segmented by color
Suggested Modifications
Want to see the task count for every due date?
1. Navigate to the Configure panel on the right-hand side.
2. Select Task Count.
3. Scroll down to the Display section.
4. Check the box next to Detail Labels.
Primary Use Case Scenario
An Operations Manager reviews this report weekly to identify upcoming spikes in task volume based on due dates and track whether task completion is keeping pace with upcoming deadlines.
Actionable Insights
A clear tread-line showing how open tasks are distributed across future dates and insight into whether task volume is rising or falling over time.