2024 Week 41 | Sigma: Can you create a dynamic column bar chart? 

Introduction

For this week’s challenge, we’re creating a dynamic column bar chart. The end user can select the number of columns to split the data into.

Note that there are only 37 States in the Plugs data, so do your best not to hard code anything for a more realistic use case!

Have fun!
-Katrina

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

  • Create a bar chart showing [Cost] by Store State in descending order
  • Create a slider control letting the end user choose to display the data in 1-4 columns
  • Maintain the sort order when changing the number of columns
    • (Try filtering by Region to confirm your sort and dynamic column calculations will adjust correctly)
  • Match formatting

Dataset

Sigma Sample Database > Retail > Plugs Electronic > Plugs Electronics Hands-On Lab

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!

Scroll to Top