Headline KPIs
Filter-aware. Engineer attribution = Original Engineer (falls back to current if blank).
Quality vs Revenue — Monthly
The single best leading indicator: TPIs per $100k of revenue, split by Custom vs Standard, by month. Lower is better. Current month is excluded as in-progress.
Monthly TPIs per $100k Revenue (Custom vs Standard)
Each month's TPI count divided by the revenue of the serials touched that month (per Custom/Standard slice). Revenue is counted once per distinct serial per month so a serial with many TPIs doesn't inflate the denominator.
Trend & Volume
In-progress current month is hidden so you're not comparing partial vs whole months.
Monthly TPI Trend (Completed Months Only)
12-month trailing mean overlaid. Bars above 1σ (red) and above the mean (amber) are highlighted. Click a bar to drill into that month's TPIs.
Daily TPIs (Last 90 Days)
TPIs by Day of Week (Last 12 Months)
Deeper Trends
How the surge looks broken down by reason, by engineer, and YTD vs prior years. All charts clickable to drill.
Trend Breakdowns
First row shows what the surge is made of (reasons + engineers stacked over time). Second row shows year-over-year cumulative pace and the Custom-vs-Standard split each month.
Monthly TPIs by Reason Bucket (Top 6 Stacked)
Monthly TPIs by Top 6 Engineers
Cumulative TPIs by Year (YTD pace)
Custom % of Monthly TPIs (Last 24 Completed Months)
% Reassigned by Month (Last 24 Completed Months)
12-Week Rolling Average vs Weekly Count (Last 26 Weeks)
Engineers (Original Owner)
Each TPI counts against its Original Engineer. Custom % shows the share of an engineer's TPIs that hit Custom equipment.
By Engineer (Original)
All-time vs last-90 stacked. Click any row to drill into that engineer's TPIs.
Custom vs Standard Mix per Engineer (Top 15)
| Engineer | Total TPIs | % of Total | Last 90 | % of Recent | % Custom | Custom TPIs | Std TPIs | Distinct Serials | Top Reason Bucket | % HOT |
|---|
% HOT by Engineer (Top 15 by TPI Count)
Last-90-Day Engineer Surge (Top 15)
Equipment, Customer & Custom Mix
Where the TPIs are landing in the product line, and how revenue plays in.
Equipment x Custom/Standard (TPIs per Unit Produced)
Heat-table coloring shows where TPIs concentrate per produced unit. Click a cell to drill into the underlying TPIs.
Customer & Custom-Standard Splits
Top customers by TPI count, plus an overall Custom vs Standard breakdown.
Top 20 Customers by TPI Count
Custom vs Standard (Filtered TPIs)
Quality vs Revenue (TPIs per $100k)
Normalizes TPI count by the dollar value of the work. Lower is better. Engineers are ranked separately for Custom and Standard scope so we don't mix apples and oranges.
TPIs per $100k Revenue — by Engineer
Each engineer's filtered TPIs divided by the revenue of the serials they touched (per slice). Engineers with <$100k of revenue in scope are excluded so the ratio is meaningful. Bars are sorted worst to best.
TPIs per $100k Custom Revenue (Top 15)
TPIs per $100k Standard Revenue (Top 15)
TPIs per $100k Revenue — by Equipment Type (Custom vs Standard)
TPIs per $100k Revenue — Top 15 Customers
Revenue Coverage by Engineer (Custom vs Standard $)
Reasons, Locations & Routing
Why these TPIs get raised and where the rework lands.
Reasons
Top raw reason strings (data-quality view) on the left; keyword-bucketed root causes on the right.
Top 15 Raw Reason Strings
Top 15 Reason Buckets
Where Errors Are Caught
Location_of_Error shows where TPIs are flagged; Routed shows which workcenter the rework lands at.
Top 25 Locations of Error
Routed Workcenter Distribution
Severity & Repeat Offenders
Where to focus right now.
Severity & Flags
HOT, Red Tagged, and Outsourced flags compared all-time vs last 90 days. Trend chart shows % HOT by month over the last 24 completed months.
Severity Comparison
| Flag | All-Time | % All | Last 90 | % Recent |
|---|
% HOT by Month (Last 24 Completed Months)
Repeat-Offender Serials (5+ TPIs)
Serials with the most TPI activity. Click a row to see every TPI/QRN for that serial in chronological order.
| Serial | TPIs | QRNs | Customer | Custom | Description | Engineer | First TPI | Last TPI | Production |
|---|
Recent-Surge Spotlight (Last 90 Days)
Engineers and serials driving the surge. Cutoff: . Click any row to drill.
Engineers (Last 90)
| Engineer | TPIs | % Recent |
|---|
Top Serials in Surge
| Serial | TPIs (90d) | Customer / Equip |
|---|
Materials & Board History
Materials
Board Year Distribution
QRN Section
Quality-rework items written from the floor. SHELDON owns most of this list because he's the QRN engineer.
QRN Trends & Owners
Monthly QRN count (completed months) and QRN authors. Click a row to drill into that author's QRNs.
Monthly QRN Trend (Completed Months)
QRN Reason Buckets (Top 12)
Top QRN Authors
| Engineer | QRNs | % of Total | Last 90 |
|---|
Top Serials with Most QRNs
| Serial | QRNs | Customer / Equip | Last QRN |
|---|