Introduction Welcome to Week Forty! In my last article, Week 36, we covered how to affect multiple columns using the same filter. This week, we’re going to focus on even more advanced filtering techniques. What do you do when you want to compare multiple arrays? Luckily Sigma recently released a brand new function: ArrayIntersection. In …
Introduction This week, I wanted to challenge myself to do something I didn’t know how to do in Sigma, I wanted to start laying the groundwork to do sensitivity analysis. I’ve often thought this would be possible in Sigma, since we can connect to Snowflake User-Defined Functions (UDFs) via Sigma’s function bar to call models …
2024 Week 39 | Sigma: Can you test out changes in cost? Read More
Introduction Welcome to Week 38! Sometimes there are events or notable data points that aren’t stored in your data, but you want to see how they effect the trends. Enter reference marks and conditional formatting! This week we practice using reference marks and conditional formatting to highlight specific dates and events. The formatting styles and …
2024 Week 38 | Sigma: Can you create reference marks? 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 Welcome to Week Thirty-Six! This week, we’re going to focus on some more advanced filtering. By now, you should know how to utilize a page control’s targets to filter a single column in an element. What do you do when you need to affect multiple columns in the same element? You can utilize a …
2024 Week 36 | Sigma: Can you filter without targets? Read More
Introduction Have I expressed my deep appreciation for Input Tables? With Snowflake or Databricks, we can write back to the database, which allows for some great methods of simplifying getting user-maintained information into a database. Even though I am a big fan of input tables, it’s still risky to allow users to edit a database …
2024 Week 35 | Sigma: Can you create a support request form? Read More
Introduction Welcome to Week 34! Creating a histogram in Sigma is easy when you use the built-in Bin functions to divvy up your data. This week we’ll be creating a histogram using a two different Bin functions in Sigma and some controls to make the charts more dynamic! The formatting styles and colors in this …
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 Welcome to Week Thirty-Two! This week, we’re going to highlight one of Sigma’s latest enhancements to Actions. In this challenge, you’ll add actions to controls to show or hide columns in visualizations based on the column names selected in the control. This new action gives users more control over the data they want to …
2024 Week 32 | Sigma: Can you pick the right columns? Read More
Introduction I’ve always appreciated when developers take the time to incorporate images into their visualizations, whether it’s as simple as adding an up arrow / down arrow to denote positive or negative trends, or going all the way to showing a business’s/team’s logo when referring to them in a table. This week, I wanted to …
