Sigma

2024 Week 24 | Sigma: Can you add custom map layers?

Introduction A few weeks ago, the 19th Police District of Chicago emailed me with some interesting survey data. The visualizations were useful, but they were living inside of a Google Slides presentation, and I wanted to dig deeper into the results. Thankfully, I followed my nose to their community survey website and found that they …

2024 Week 24 | Sigma: Can you add custom map layers? Read More

2024 Week 23 | Sigma: Can you fill the donut hole?

Introduction As workbook builders we need to be thoughtful when deciding which visualizations to use in all sorts of scenarios. A good rule of thumb to help decide is looking for visualizations that provide high amounts of information to a low pixel or space ratio.  This week we’re choosing to fill the donut chart to …

2024 Week 23 | Sigma: Can you fill the donut hole? Read More

2024 Week 21 | Sigma: Can you set some boundaries?

Introduction This week, I was inspired by a post in the Sigma Community from Mark Ruesink that showed a really clever way to visualize outliers in Sigma using a combo chart and some clever calculations. Mark goes all the way to visualizing outliers, so I definitely recommend checking out his full post, but I wanted …

2024 Week 21 | Sigma: Can you set some boundaries? Read More

2024 Week 20 | Sigma: Can you create quadrants?

Introduction Week 20 already! Crazy how fast the year is going by…and how fast you’re skilling up in Sigma! I love scatter plots. They’re a great way to display a lot of information in an easily consumable package. Layering quadrant colors on top, make it even easier to visually group dots and find outliers.  -Katrina …

2024 Week 20 | Sigma: Can you create quadrants? Read More

2024 Week 19 | Sigma: Can you clean a string?

Introduction After last week’s awesome product launch, I was thinking about some of the Sigma features that we have not yet highlighted in Workout Wednesday. One of those is Custom Functions, and while the ability to create Custom Functions is currently reserved for admins, it’s a great feature for users to be aware about when …

2024 Week 19 | Sigma: Can you clean a string? Read More

2024 Week 17 | Sigma: Can you Cohort These Customers?

Introduction Welcome to Week Seventeen! This week, you’re going to perform a Cohort Analysis of food truck customers based on when they placed their first order.  Conditional formatting will help highlight which cohorts have a greater percentage of customers in them. As a bonus, you will implement a dynamic page control input to let the …

2024 Week 17 | Sigma: Can you Cohort These Customers? Read More

2024 Week 15 | Sigma: Can you identify the top, average, and bottom profitable customers? 

Introduction This week, we’re building a staple in my bar chart library: Top, Bottom, and Other Values. I often use this bar chart to easily show the breadth of the outliers while not losing sight of the typical. This challenge is also a great example of the flexibility of modeling at different levels of granularity …

2024 Week 15 | Sigma: Can you identify the top, average, and bottom profitable customers?  Read More

Scroll to Top