Under-defined vs fully-defined vs over-defined in Solidworks - Dashboard Approaches Compared

Dashboard Mode - Under-defined vs fully-defined vs over-defined

Goal

Understand how many parts in a SolidWorks assembly are under-defined, fully-defined, or over-defined to improve design stability.

Sample Data

Part ID	Part Name	Definition Status	Number of Constraints
1	Bracket	Under-defined	2
2	Base Plate	Fully-defined	5
3	Arm	Over-defined	7
4	Pin	Fully-defined	5
5	Cover	Under-defined	3
6	Screw	Fully-defined	5
7	Spring	Over-defined	8

Dashboard Components

• KPI Cards: Show count of parts by definition status.
  Formulas:
  Under-defined count = COUNTROWS(FILTER(Parts, Parts[Definition Status] = "Under-defined")) = 2
  Fully-defined count = COUNTROWS(FILTER(Parts, Parts[Definition Status] = "Fully-defined")) = 3
  Over-defined count = COUNTROWS(FILTER(Parts, Parts[Definition Status] = "Over-defined")) = 2
• Bar Chart: X-axis: Definition Status, Y-axis: Number of Parts.
  Shows counts of parts per status.
• Table: Lists all parts with their definition status and number of constraints.

Dashboard Layout

+----------------------+----------------------+----------------------+
|  KPI: Under-defined   |  KPI: Fully-defined  |  KPI: Over-defined   |
|      Count: 2        |      Count: 3        |      Count: 2        |
+----------------------+----------------------+----------------------+
|                      Bar Chart: Parts Count by Definition Status                      |
|               (Under-defined, Fully-defined, Over-defined)                         |
+------------------------------------------------------------------------------------+
|                                Table: Parts Details                                |
| (Part ID, Part Name, Definition Status, Number of Constraints)                      |
+------------------------------------------------------------------------------------+

Interactivity

Adding a filter by Definition Status updates the bar chart and table to show only parts matching the selected status. The KPI cards remain visible to show overall counts.

Self Check

If you add a filter to show only Fully-defined parts, which components update?

• The bar chart updates to show only the count for Fully-defined parts.
• The table updates to list only Fully-defined parts.
• The KPI cards remain unchanged, showing total counts for all statuses.

Key Result

Dashboard shows counts and details of SolidWorks parts by their definition status: under-defined, fully-defined, and over-defined.