Extruded cut 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 many parts in the latest design batch use the 'Extruded cut' feature, including the average depth of these cuts.

📊 Data: You have a dataset listing parts with their features, feature types, and dimensions including cut depth.

🎯 Deliverable: Create a dashboard showing the count of parts with 'Extruded cut' features and the average cut depth.

Sample Data

PartID	FeatureName	FeatureType	CutDepth_mm
101	Cut1	Extruded cut	5
102	Hole1	Hole	3
103	Cut2	Extruded cut	7
104	Fillet1	Fillet	0
105	Cut3	Extruded cut	4
106	Boss1	Boss	0
107	Cut4	Extruded cut	6
108	Hole2	Hole	2

1

Step 1: Filter the dataset to include only rows where FeatureType is 'Extruded cut'.

Use filter condition: FeatureType = 'Extruded cut'

Expected Result

Rows with PartID 101, 103, 105, 107 remain.

2

Step 2: Count the number of unique PartIDs with 'Extruded cut' features.

Count distinct PartID from filtered data

Expected Result

4 parts have 'Extruded cut' features.

3

Step 3: Calculate the average CutDepth_mm for the filtered 'Extruded cut' features.

Average of CutDepth_mm where FeatureType = 'Extruded cut'

Expected Result

Average cut depth is (5 + 7 + 4 + 6) / 4 = 5.5 mm.

4

Step 4: Create a dashboard with two cards: one showing the count of parts with 'Extruded cut', and one showing the average cut depth.

Card 1: Count of parts = 4 Card 2: Average cut depth = 5.5 mm

Expected Result

Dashboard displays '4 parts with Extruded cut' and 'Average cut depth: 5.5 mm'.

Final Result

-----------------------------
| Parts with Extruded Cut: 4 |
| Average Cut Depth: 5.5 mm  |
-----------------------------

✓Four parts in the batch use the 'Extruded cut' feature.

✓The average depth of these cuts is 5.5 millimeters.

Bonus Challenge

Add a trend chart showing the number of parts with 'Extruded cut' features over the last 6 months.

Show Hint

Use the part creation date to group counts by month and plot a line chart.