0
0
Solidworksbi_tool~8 mins

Revolved cut in Solidworks - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Revolved cut
Business Question

How can we analyze the usage and efficiency of the Revolved Cut feature in our SolidWorks designs?

Sample Data
Design ID Revolved Cut Count Material Removed (cm³) Time Saved (minutes) Designer
D001 3 150 20 Alice
D002 5 230 35 Bob
D003 2 120 15 Charlie
D004 4 200 30 Alice
D005 1 80 10 Bob
Dashboard Components
  • KPI Card: Total Revolved Cuts
    Formula: SUM(Revolved Cut Count) = 3+5+2+4+1 = 15
  • KPI Card: Total Material Removed (cm³)
    Formula: SUM(Material Removed) = 150+230+120+200+80 = 780
  • KPI Card: Total Time Saved (minutes)
    Formula: SUM(Time Saved) = 20+35+15+30+10 = 110
  • Bar Chart: Revolved Cuts by Designer
    Data: Group by Designer, sum Revolved Cut Count
    Results: Alice=7, Bob=6, Charlie=2
  • Table: Detailed Design Data
    Shows all columns from sample data
Dashboard Layout
+----------------------+-------------------------+
| Total Revolved Cuts   | Total Material Removed  |
|        [ 15 ]        |         [ 780 cm³ ]     |
+----------------------+-------------------------+
| Total Time Saved      |                         |
|      [ 110 min ]     |                         |
+----------------------+-------------------------+
|                                              |
|   Bar Chart: Cuts by Designer                 |
|                                              |
+----------------------------------------------+
|                                              |
|          Table: Detailed Design Data          |
|                                              |
+----------------------------------------------+
Interactivity

Adding a filter by Designer updates all KPI cards, the bar chart, and the detailed table to show data only for the selected designer(s). For example, selecting "Alice" will show total cuts, material removed, and time saved only for Alice's designs.

Self Check

If you add a filter for Designer = Bob, which components update?

  • All KPI cards update to show Bob's totals: Revolved Cuts = 6, Material Removed = 310 cm³, Time Saved = 45 minutes.
  • The bar chart highlights Bob's data.
  • The detailed table shows only Bob's designs (D002 and D005).
Key Result
Dashboard showing total revolved cuts, material removed, and time saved by designer with detailed data and interactive filtering.