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

Introduction

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!
-Katrina

Need access to Sigma?

Click here to Watch: How to Register & Get Started with Sigma WoW

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
- 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

Dataset

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.