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 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 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 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 …
2024 Week 41 | Sigma: Can you create a dynamic column bar chart? Read More
Introduction This week’s challenge is a bit different; you have two options! Imagine you’re creating a workbook showing off all the cool features and functionalities to your coworkers and want to provide a curated list of Sigma’s help documentation. In this challenge, you’ll create an embedded documentation element enabling the end users to choose a …
2024 Week 37 | Sigma: What would you like help with? Read More
Introduction Sigma is all about making data manipulations and explorations accessible to everyone! This week’s challenge might sound intimidating, extracting data from JSON, but Sigma makes it a breeze. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How to Register & Get …
2024 Week 33 | Sigma: Can you find the safe to eat items? Read More
Introduction This week’s challenge was inspired by a lively discussion I was a part of, covering what date calculations a data analyst should or should not know. We’ve already covered several common ones, such as the current time period vs the prior time period. So this week, I wanted to add another to the list: …
2024 Week 30 | Sigma: Can you show partial or whole months? Read More
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
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 …
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
