Can you take Action?
In this blog, we'll solve the WOW2024 W12 Sigma Computing Challenge. Workbook Actions are a great way to increase the functionality and flexibility of your analytics. With Actions, we can change what a user sees, how they see it, and the level of detail in our analysis. Let's dive in!
Step 1: An overview of the challenge objectives - 0:22
Step 2: Getting the data ready - 0:44
Step 3: Creating the bar and line chart - 1:03
Step 4: Creating the filter options - 2:45
Product Type Filter - 3:12
Store Region Filter - 3:43
Step 5: Create Actions - 4:05
Filtering a Region Action - 4:32
Showing Store States - 5:03
Addressing missing Region Filter - 5:57
This step is optional depending on how you created your bar chart and the order in which you created your actions. Reviewing this step can help you troubleshoot actions if they aren't acting as expected.
Showing Store Region Again - 6:58
Step 6: Resort bars - 7:40
Step 7: Final formatting - 8:12