Introduction Welcome back to another challenge. This week we’re tackling some financial data and in particular, a waterfall chart based on multiple measure columns. Can you handle it? Click to open in Tableau Public Requirements Dashboard Size 800 x 600 One worksheet Create a waterfall chart for Gross Sales Discounts Net Sales COGS Profit Create …
#WOW2024 | 36 | Can you build a Measure Names Waterfall? 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 Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …
2024 Week 36 | Power BI: Recreate a NYT Interactive Article 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 Overlapping histograms with normal curve overlays are used to compare the distribution of a numerical variable across different groups such as male and female body mass. With this we can glance the central tendency, spread, and skewness of the data within each group and also how well the data follows a normal distribution. The …
2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve Read More
Introduction A huge thank you to Valerija Kirjackaja for sharing this fantastic challenge with us. It’s a little trickier than last week, this one is a classic #WOW – simple on the surface with lots of tricks behind the scenes. Reordering a chart using set or parameter actions is a pretty common use case – …
#WOW2024 | Week 35 | Advanced Parameter/Set Action Read More
Introduction This week’s challenge is provided by guest contributor Erik Svensen https://www.linkedin.com/company/catmansolution. The workout will use visual calculations in combination with numeric parameters to highlight a period in a development chart. (Please note visual calculations do not currently publish to web) Requirements 1. Retrieve the data from Google Sheets – (you only need orders)2. Add …
2024 Week 34 | Power BI: Visual Calcs and Parameters 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 Have you ever received a request to make the data displayed on a dashboard different depending on who is viewing it? For example, let’s think about a scenario where the sales for each sub-category are displayed, but the sub-categories shown vary depending on the viewer. It’s straightforward if one sub-category is to be displayed for …
#WOW2024 | Week 34 | Can You Control the Displayed Data Based On Sub-Category Assignment? 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
