Chamfer feature on edges in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product design analyst at a manufacturing company.

📋 Request: Your manager wants a report showing how often chamfer features are applied to edges in recent product designs and the typical chamfer sizes used.

📊 Data: You have access to a dataset listing product parts, edges, whether a chamfer is applied, and the chamfer size in millimeters.

🎯 Deliverable: Create a dashboard showing the count of edges with chamfers, average chamfer size, and a breakdown by product part.

Sample Data

PartID	EdgeID	ChamferApplied	ChamferSize_mm
P001	E01	Yes	1.5
P001	E02	No	0
P002	E01	Yes	2.0
P002	E02	Yes	1.0
P003	E01	No	0
P003	E02	Yes	1.2
P004	E01	Yes	1.8
P004	E02	No	0

1

Step 1: Filter the data to include only edges where ChamferApplied is 'Yes'.

Filter condition: ChamferApplied = 'Yes'

Expected Result

5 rows with chamfer applied

2

Step 2: Calculate the total count of edges with chamfers.

Count of rows after filter

Expected Result

5

3

Step 3: Calculate the average chamfer size across all edges with chamfers.

Average(ChamferSize_mm) where ChamferApplied = 'Yes'

Expected Result

Average chamfer size = (1.5 + 2.0 + 1.0 + 1.2 + 1.8) / 5 = 1.5 mm

4

Step 4: Group the filtered data by PartID and calculate count of chamfered edges and average chamfer size per part.

Group by PartID; calculate COUNT(EdgeID), AVERAGE(ChamferSize_mm) for ChamferApplied = 'Yes'

Expected Result

P001: Count=1, Avg=1.5; P002: Count=2, Avg=1.5; P003: Count=1, Avg=1.2; P004: Count=1, Avg=1.8

5

Step 5: Create a dashboard with: - A card showing total chamfered edges (5) - A card showing average chamfer size (1.5 mm) - A bar chart with PartID on X-axis and count of chamfered edges on Y-axis - A line chart overlay showing average chamfer size per part

Configure visuals accordingly in BI tool

Expected Result

Dashboard displays counts and averages clearly by part

Final Result

Bar Chart: Chamfer Count by PartID

↓

Line Chart: Avg Chamfer Size by Part

✓Five edges across four parts have chamfers applied.

✓The average chamfer size is 1.5 mm overall.

✓Part P002 has the most chamfered edges (2).

✓Chamfer sizes vary slightly by part, with P004 having the largest average size.

Bonus Challenge

Add a filter to the dashboard to select parts with average chamfer size above a user-defined threshold.

Show Hint

Use a slicer or filter control on the average chamfer size measure to dynamically update the visuals.