Introduction
For this week, we’re exploring row order dependant calculations. In this scenario, we’re trying to understand how our hometown baseball team’s winning streak impacts attendance. Are folks more likely to attend if the team keeps winning? Let’s find out!
Have Fun!
Katrina
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
- Create a calculation to identify the game number in this winning streak
- For example, if there are two wins in a row, that would be game 2 of the winning streak
- Hint: If the previous game was a loss, the streak starts over at 0
- Create a bar chart showing the attendance by game day colored by the winning streak number
- Feel free to choose any colors
- Map the path of the flight, from the origin location to the arrival location
- Add a pivot table with the streak ID grouping, game date ([Date]), game result, and attendance
- Hint: Streak ID is how many streaks the team has had in the whole season
- Add a bar chart showing the average of attendance by
- Match other formatting
Dataset
RETAIL > MLB_STADIUM_SALES > D_HOME_GAMES
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, Katrina Menne, and Michal Shaffer!
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…