Introduction
Welcome to Week 32 of 2025!
This week, we’re going to have a little summer fun comparing roller coasters. This prompt is less prescriptive than usual to give you the freedom to let your creativity flourish.
Where do your favorites fall?
Good luck!
-Ashley
Need access to Sigma?
Note: You will only have view access to WOW Workbooks, Folders, and Workspaces, not edit access. Please create your WOW Workbooks under “My Documents.” We suggest creating a folder to organize all your workbooks.
Requirements
- Hidden Data Sheet:
- Workout Wednesday/2025/2025W32 – Can you ride it out? / Roller Coasters
- This will be the base underlying data
- Workout Wednesday/2025/2025W32 – Can you ride it out? / Roller Coasters
- Your final workbook should display only these elements:
- A popover that contains:
- Filters for all dimensional information, each using a control type appropriate for the suggested values
- A Top N filter that affects the bar graph
- A segmented control that lets users select a Color Dimension to be used in the charts: Manufacturer, Material Type, Seating Type, or Status
- A button that resets all of these filters to their default values
- A horizontal bar graph that shows the Top N Total Inversions by Park and Color Dimension
- Hint: In order to get the Top N to work correctly with a Color dimension, you’ll need to use an intermediary table
- A scatter plot that shows Height and Length by the Color Dimension and Speed
- Hint: Do not aggregate the Y-Axis to get a true scatter plot.
- Food for thought: There are some significant Height outliers. How can you minimize the amount of whitespace in your graph?
- A popover that contains:
- Finishing Touches
- Give the dashboard a descriptive title
- Use dynamic text in your chart titles to display the chosen Color Dimension
- Add the coaster’s Name to each ToolTip
- Arrange your elements into a cohesive dashboard
- Update your workbook’s settings to give it a more personalized flair
- Tips
- Create columns that find the Color Dimension and Color Dimension Column Name in your base table. These calculations will only need to be made once and can be utilized in multiple places
- Put all controls into a container to make resetting to their published values quick and easy.
Dataset
- Workout Wednesday/2025/2025W32 – Can you ride it out? / Roller Coasters
Share
After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2024 and #SigmaComputing, and tag Ashley Bennett, Eric Heidbreder, Jessica Batten, and Carter Voekel!
Create an interactive, sharable version of your solution here.
Also, make sure to fill out the Submission Tracker so that we can count you as a participant this week to track our participation throughout the year.
Solution
Coming soon….