2024 Week 3 | Sigma: Can you choose the right value?


Welcome to week Three! This week, we’ll build off of the skills from last week. I strongly advise checking it out before tackling this one. 

This challenge is meant to be a little tricky, but I have faith in you! This week will help you learn when to choose the correct option. Sigma often offers multiple solutions to the same or very similar outcomes. 

In this challenge, we’ll create a way for end users to choose what to display and what level of granularity to show and have a dynamic label. 

 Good Luck!

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. 


  • Add a data element from PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA
    • Sigma Sample Database > Retail > Plugs_Electronics
    • Note that ‘Profit’ is hiding in the ‘Metrics’ tab.
  • Hidden Data Tab
  • Add two options to select different locations and measure options
  • Add a horizontal bar chart
    • Y-Axis displays the chosen Location Options:
      • None, Store Region, Store State, Store City, Store Name
    • Hidden Grid lines for X-Axis
    • X-Axis displays the chosen measure value:
      • Average Price
      • Sum of Price
      • Sum of Cost
      • Sum of Profit
    • X-Axis custom measure value format: “$,.2s”
  • Viz/Bar Marks Color: #1976D2
  • Data Label Format
    • Color: #0A0A0A 
    • Position: Outside
    • Display: All
  • Add a dynamic Title Text Element showing the selected value by the selected location drill-down option.
    • Size: Small Heading
  • Viz Element Size: any size
  • Optional: Vertical Divider between title and control elements


Sigma Sample Database > Retail > Plugs_Electronics


After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2024 and #SigmaComputing, and tag Adrian Segura, 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.


Scroll to Top