Introduction Surprise! I have one more challenge for the year. This challenge was inspired by a workbook I created in my early Sigma days. We wanted to track weekly progression toward a quarterly total. Sounds easy, right? I thought so, too! But then I realized that DateTrunc(“week,” [Date]) would duplicate the week label across quarters. …
2024 Week 51 | Sigma : Can you calculate weekly progress? Read More
Introduction Welcome to Week 50! This week we’re playing with a new Sigma feature – modals! Modals are pop-ups that can contain any elements that you might otherwise have in another tab. There is so much opportunity with this feature, particularily when combined with actions! The formatting styles and colors in this challenge are all …
Introduction This week, we’re diving into how to link a single color across multiple elements, giving users the power to choose which item gets the color splash. Plus, we’re checking out the latest tweaks to the Trellis options to make your visualizations even cooler. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up …
2024 Week 49 | Sigma: Can you create a highlight action? Read More
Introduction Welcome to Week Forty-Eight! This week, I am heavily focused on my Thanksgiving preparations, so naturally, we will be taking our Workout Wednesday to the kitchen. I asked Chat GPT to generate us a dataset involving popular Thanksgiving dishes by state. We’re going to use that to utilize some newer features, like a conditional …
2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes? Read More
Introduction I felt like I was seeing more news about food recalls lately, and I did the thing any good data-minded individual would do: pulled down data from the FDA to see if what I’m feeling is backed up by data. When I pulled the data down from, I realized there was still a lot …
Introduction Welcome to Week 46! This week we pretend to be a streaming service, trying to see which of our 3 new shows are doing well with the viewer base. Funnel charts will be our main focus here, but feel free to play around with the sample data to find other key insights! The formatting …
2024 Week 46 | Sigma: Can you create a Funnel Chart? Read More
Introduction Hey everyone! This week’s Workout Wednesday focuses on creating clear, actionable patient demographic visuals using a Sankey, a KPI, and two bar charts—binned and unbinned. Here’s the setup: the Sankey chart helps us map distribution, while the KPI delivers an at-a-glance view of a key metric to ground the analysis. With the bar charts, …
2024 Week 45 | Sigma: Can you create these patient demographic visuals? Read More
Introduction Welcome to Week Forty-Four! This week, I wanted to have a little fun because not only is Thursday Halloween, but it’s also my birthday. As someone who loves data and shares her birthday with a holiday, I am interested to see just how common holiday birthdays are. In this challenge, you will use a couple …
2024 Week 44 | Sigma: How likely is a holiday birthday? Read More
Introduction This week, I wanted to highlight Sigma’s actions once again, as we got a new update a last week: The ability to change date controls via actions! Pairing this new feature with the ‘Conditions’ beta feature in actions, we can create more user-friendly date filtering with much less hassle. Stay up to date on changes to …
2024 Week 43 | Sigma: Can you create a segmented date control? Read More
Introduction Welcome to Week 42! This week we’ll look at an easy way to compare data year over year, whether we are using a line chart visualization or a pivot table to view our data. There are many ways to acheive similar results, this is just one! Feel free to play around with other ways …
2024 Week 42 | Sigma: Can you compare Year over Year Data? Read More
