2025 Week 23 | Sigma: Can You Compare Two NHL Teams?

Introduction

It’s Stanley Cup Playoff day, and I must EDMit I have a preference for who I’d like to win. This week, I’m revisiting an old challenge I made and improving it by using Sigma’s new “Transpose” functionality. This little gem slipped in without me noticing and has been a beautiful addition to my Sigma toolkit.

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

  1. Add a new table element in your source tab
    • Tables and Datasets > Workspaces > Workout Wednesday > 2025W23 – Can you compare two NHL teams? > Stanley Cup Playoff Teams > Teams
  2. Transpose the Teams table (Column to Row), so you have three columns: Team, Stat, Value
    • Group this table by stat
    • Add a ‘Max Value’ calculation to that group
    • Because we want Edmonton to win, create a ‘Value Flipped’ column
      • If([team] = “FLA”, [Value] * -1, [Value])
    • Create a ‘Winner’ column, which will help us color the bars later
      • If(In([Stat], “GAA”, “PIM”, “PPGA”, “SA/G”, “SHGA”), [Value] != [Max Value], [Value] = [Max Value])
  3. Create your horizontal bar chart
    • Create a bar chart, set the source as the Transposed table from step 2
    • Flip the bar to horizontal
    • Add “Stat” to the Y-Axis
    • Add “Value Flipped” to the X-Axis
    • Add “Winner” to the Color
      • Customize the colors so that ‘False’ is grey, and ‘True’ is Green (or some other color)
    • Add “Team” to the Tooltip
    • Update formatting
      • Hide the title of your bar chart
      • Y-Axis
        • Increase font size
        • Show gridlines
      • X-Axis
        • Hide Gridlines
        • Uncheck “Show Zero Guideline”
      • Legend
        • Hide it!
      • Data Labels
        • Show Data Labels
        • Increase Font Size
        • Set color to Black
      • Gaps
        • Gap Width: Small
  4. Add Images, if you’d like!

Dataset

Tables and Datasets > Workspaces > Workout Wednesday > 2025W23 – Can you compare two NHL teams? > Stanley Cup Playoff Teams > Teams

Share

After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2025 and #SigmaComputing, and tag Ashley Bennett, Eric Heidbreder, Katrina Menne, and Carter Voekel!

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