Offset entities in Solidworks - Dashboard Guide

Dashboard Mode - Offset entities

Business Question

How can we analyze the use of the Offset Entities feature in SolidWorks sketches to improve design efficiency and accuracy?

Sample Data

Sketch ID	Original Entity Length (mm)	Offset Distance (mm)	Offset Entity Length (mm)	Number of Offset Entities	Design Time Saved (minutes)
SK001	100	5	110	3	15
SK002	150	10	170	5	25
SK003	80	3	86	2	10
SK004	120	7	134	4	20
SK005	90	4	98	3	12

Dashboard Components

• KPI Card: Total Offset Entities
  Formula: SUM([Number of Offset Entities])
  Result: 17
• KPI Card: Average Design Time Saved (minutes)
  Formula: AVERAGE([Design Time Saved (minutes)])
  Result: 16.4
• Bar Chart: Offset Distance vs. Number of Offset Entities
  X-axis: Offset Distance (mm)
  Y-axis: Number of Offset Entities
  Shows how offset distance relates to how many entities are offset
• Line Chart: Original Entity Length vs. Offset Entity Length
  X-axis: Sketch ID
  Y-axis: Length (mm)
  Lines: Original Entity Length and Offset Entity Length
  Shows length increase after offset
• Table: Detailed Sketch Data
  Columns: Sketch ID, Original Entity Length, Offset Distance, Offset Entity Length, Number of Offset Entities, Design Time Saved

Dashboard Layout

+----------------------+-----------------------+
| Total Offset Entities | Average Design Time    |
|        (KPI)         | Saved (KPI)           |
+----------------------+-----------------------+
|                                              |
|  Bar Chart: Offset Distance vs. Number of    |
|  Offset Entities                              |
|                                              |
+----------------------------------------------+
|                                              |
|  Line Chart: Original vs. Offset Entity Length|
|                                              |
+----------------------------------------------+
|                                              |
|  Table: Detailed Sketch Data                  |
|                                              |
+----------------------------------------------+

Interactivity

Adding a filter for Offset Distance allows users to select a range of offset distances. This filter updates:

• The Bar Chart to show only selected offset distances
• The Line Chart to display only sketches within the selected offset distance range
• The Table to list only the filtered sketches
• The KPI Cards recalculate totals and averages based on the filtered data

Self Check

If you add a filter to show only sketches with an Offset Distance greater than 5 mm, which components update and how?

• The Bar Chart will display bars only for offset distances above 5 mm.
• The Line Chart will show data points for sketches with offset distances above 5 mm.
• The Table will list only sketches SK002 and SK004.
• The KPI Cards will recalculate totals and averages based on these filtered sketches.

Key Result

Dashboard analyzing Offset Entities usage in SolidWorks sketches showing totals, averages, and relationships between offset distance and design efficiency.