Complex~38min

The Defect Rate Trending Up Undetected

LINE-A's rolling 4-week defect rate has climbed steadily for 12 weeks, from 2.0% to 9.0% — a real emerging quality problem. But the weekly QA report only ever compares this year to the same week last year, and last year had its own one-off supplier defect spike in those same weeks (up to 8.0%), so year-over-year this week reads as "+1 point, not alarming." Four other lines are flat at 2% all year on both the rolling and YoY view.

Tables you'll query

production_linesweekly_defects

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →