What is task completion rate, and how do you measure it in Metabase?
Task completion rate is completed work divided by work due, committed, or planned in a period. Use it to understand whether teams finish the work they expected to finish, not to rank individuals.
TL;DR — Pick one denominator: due work, committed work, or planned work. Exclude archived, canceled, duplicate, and test items.
Definition
Task completion rate = completed items ÷ due or committed items. For weekly reporting, due-date based completion is the easiest cross-tool definition.
Data needed
completed_ator a done statusdue_dateor a committed/planned period- Archived/canceled flags to exclude non-work
- Project, owner, team, and work type for segmentation
SQL pattern
Task completion rate by weekPostgreSQL
SELECT
date_trunc('week', due_date) AS week,
COUNT(*) FILTER (WHERE completed_at IS NOT NULL) AS completed_items,
COUNT(*) AS due_items,
ROUND(
100.0 * COUNT(*) FILTER (WHERE completed_at IS NOT NULL)
/ NULLIF(COUNT(*), 0),
2
) AS task_completion_rate
FROM work_items
WHERE due_date IS NOT NULL
AND archived_at IS NULL
AND canceled_at IS NULL
GROUP BY 1
ORDER BY 1;Pitfalls
Changing the denominator between dashboards.→ Due work, committed work, and planned work answer different questions.
Ignoring missing due dates.→ Track missing due dates separately or they silently disappear from due-date completion.
Using completion rate as an individual scoreboard.→ Work size and interruption load vary; use it as a team planning metric.
Related
FAQ
Should I use due date or sprint commitment?
Use due date for broad work-management tools and sprint/cycle commitment for agile delivery. Label the denominator so readers know what the rate means.