Manufacturing file review in PCB Design - Dashboard Guide

Dashboard Mode - Manufacturing file review

Goal

Understand the quality and readiness of manufacturing files for PCB production by reviewing key metrics like file completeness, error counts, and approval status.

Sample Data

File Name	File Type	Completeness (%)	Error Count	Approval Status	Review Date
Board_A_Gerber	Gerber	100	0	Approved	2024-06-01
Board_A_Drill	Drill	95	2	Pending	2024-06-01
Board_B_Gerber	Gerber	98	1	Approved	2024-06-02
Board_B_Drill	Drill	90	3	Rejected	2024-06-02
Board_C_Gerber	Gerber	100	0	Approved	2024-06-03
Board_C_Drill	Drill	100	0	Approved	2024-06-03

Dashboard Components

• KPI Card: Average Completeness
  Formula: Average of Completeness (%) across all files.
  Result: (100 + 95 + 98 + 90 + 100 + 100) / 6 = 97.17%
• KPI Card: Total Errors
  Formula: Sum of Error Count.
  Result: 0 + 2 + 1 + 3 + 0 + 0 = 6
• Bar Chart: Error Count by File Type
  Data: Sum of errors grouped by File Type.
  Gerber: 0 + 1 + 0 = 1
  Drill: 2 + 3 + 0 = 5
• Table: File Details
  Shows all columns from sample data for detailed review.
• Pie Chart: Approval Status Distribution
  Counts of files by Approval Status.
  Approved: 4
  Pending: 1
  Rejected: 1

Dashboard Layout

+----------------------+----------------------+
| Average Completeness | Total Errors         |
|      (KPI Card)      |      (KPI Card)      |
+----------------------+----------------------+
|      Error Count by File Type (Bar Chart)      |
+-----------------------------------------------+
| File Details (Table)                           |
+-----------------------------------------------+
| Approval Status Distribution (Pie Chart)      |
+-----------------------------------------------+

Interactivity

Filter by Approval Status: Selecting a status (e.g., Approved) updates the table, KPI cards, and charts to show only files with that status.

Filter by File Type: Selecting Gerber or Drill updates error counts and file details accordingly.

Self Check

If you add a filter for Approval Status = 'Approved', which components update?

• KPI Cards: Average Completeness and Total Errors recalculate for approved files only.
• Bar Chart: Error Count by File Type shows errors only for approved files.
• Table: File Details shows only approved files.
• Pie Chart: Approval Status Distribution updates to show only the selected status slice.

Key Result

Dashboard shows manufacturing file completeness, errors, and approval status for PCB production files.