Introduction
For this week’s challenge, we’re exploring Sigma’s workbook actions, a powerful feature that enables better end-user experiences, nuanced data exploration, and more impactful presentations.
Sigma’s workbook actions cover a wide range of interactions, but for this first challenge, we’ll focus on two common action scenarios: clicking to filter and clicking to change.Â
As you complete this challenge, note each element’s entire behavior, not just what is in the gif below. đ§
Enough talk, let’s take action!
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
- Add a data element from PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA
- Sigma Sample Database > Retail > Plugs_Electronics
- Rename Price to Sales and apply the custom format of $,.3s
- Create a Horizontal Display Bar chart showing Sales by Region
- Match title and subtitle
- Hide X-Axis Grid Lines
- Hide Legend
- Display all Data Labels
- Color by Region
- Hint: I suggest naming your color field something distinctive
- East #E15658
- Midwest #EB6E1E
- South #F1CE63
- Southwest #71B965
- West #4E79A7
- Create a Cost by Region and Quarter Line Chart
- Match title
- Format Quarter to Q%q-%Y
- Hide Legend
- Hide Data Labels
- Match line style: Smooth, solid, 2px, with Circle Style Points, 8px
- Color by Region
- East #E15658
- Midwest #EB6E1E
- South #F1CE63
- Southwest #71B965
- West #4E79A7
- Create a Store Region List Control Element
- Match Element Properties
- Create a Product Type List Control Element
- Match Element Properties and Functionality
- Create a Workbook Action that
- Filters the bar and line elements to the clicked on Region
- Changes the bar chart Y-Axis to the States within that Region
- Changes the bar chart Y-Axis back to all Regions when clicked again
- Hide Data Tab
- Add the Medium heading page title
Dataset
Sigma Sample Database > Retail > Plugs_Electronics > Hands_On_Lab_Data
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, and Katrina Menne!
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
