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.
What does a task completion rate chart look like in Metabase?
Chart completed items over items due each week and read the level: the rise from about 71% to 84% means planning is getting more honest — teams are committing to amounts they actually finish. A one-week dip like May 18's usually marks an interrupt-heavy week, so check what unplanned work arrived before treating it as a planning failure.
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 week PostgreSQL
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.