Introduction
This week is a guest post from Jess Batten!
Welcome to Week 10!
Have you ever wanted to compare different levels within a data set? How does state performance compare to the whole region? What about if you then want to compare city performance to the state?
This week we’re going to try to build a report that allows the end user to not only compare values at different levels of granularity but also dynamically decide what those levels are!
Let’s give it a shot!
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
Requirements
- Create Profit field in the data: (Price – Cost) * Quantity
- Create a grouped table that has average profit at the following levels: Region, State and City
- Create three controls that will create the dynamic selections (hint: you might need to add some columns to your grouped table)
- Let the user decide the comparison levels: Region vs State, Region vs City, State vs City
- Let the user select a value from the first comparison level (i.e. select a specific region)
- Let the user select a value from the second comparison level (i.e. select a specific state)
- Create a bar chart that will show the avg profit for each selection
- Use any colors you would like for the bars!
- Extra Credit: Create a control that will allow the user to trellis the chart by product family, product type, product line
Dataset
Sigma Sample Database > RETAIL > PLUGS_ELECTRONICS > 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, 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…