Introduction Hello and welcome to Week 34! Let’s get the fun started this week with Rows and Columns Total in the Pivot Table! Yes, you heard that right, we want to sum the rows and columns and yet have all the data show. Requirements Create a dev org or use an existing org you have […]
Pivot – Rows and Columns Total Read More »
Introduction This post is special! It has been sent by Pedro Gagliadri who has been working on CRM Analytics since it was called Wave! Yes, some of us have been using this tool forever! Now for the challenge: This Outliers Detection will use Z-Scores. Prepare a recipe and a dashboard that allows you to see
Outliers Detection in CRM Analytics Read More »
Introduction We are already into the mid 2024 and hope you are ready for another challenge! This is hopefully easier than some of the previous challenges we have set in CRM Analytics this year! It contains windowing function with input widgets. Yes, you read that right! Two great tools that can make your and your
Windowing with Input Widgets (Energy Data) Read More »
Introduction It’s the 18th week of the year and time for another CRM Analytics challenge! This week’s task is to rank the energy dataset by country for each year and create one chart out of it. This chart will show the least and most energy consumed based on the type of energy consumption selected. Sounds
Playing with Ranks in CRM Analytics! Read More »
Introduction Another month another week and we are already in the second quarter of the year! Let’s start this quarter strong and use timeseries in dashboards. This week is based on similar dataset as the week 4 and 9 but has been organized by energy types as a column! The challenge is to create a
2024 Week 14 – Timeseries in CRMA! Read More »
Introduction Almost the end of February! Time flies fast! – And another WoW Challenge is here!! This week is based on the same dataset and maps we had as a challenge during Week 4! The changes are adding one KPI, and one top 5 chart to the existing dashboard. Then add an Interaction (not binding)
2024 Week 09 – Formulate Select and Navigate Dashboard Read More »
Introduction We are already into the 4th week of the year – WOW!! My first time creating a WoW challenge. This one is based on maps! Yes, I know CRM Analytics maps make us desire for better versions, but we can always do cool things with what already exists. But, but… this one is not
2024 Week 04 – Maps and Interactions/Bindings Read More »
Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new
2023 Week 01 | Power BI: Use DAX to control visual display Read More »
Introduction This challenge focuses on a powerful Power BI technique: conditional visibility using overlapping visuals and dynamic transparency. Instead of hiding visuals entirely, you’ll learn to control visibility through background color transparency – making elements appear and disappear based on user selections. Based on the selection of countries, we are looking at differences in foreign
2026 Week 10 | Power BI: Dynamic visibility of visuals Read More »
Introduction This week, we will leverage AI functions and CallNumber warehouse functions to explore the possibility of Sigma’s scheduled action trigger. Imagine you are the branch manager of a customer support center and a ticket assignment has to be sent out every morning to all your agents, such that each agent will have a list
2026 Week 10 | Sigma: Scheduled Automation Read More »
Introduction Frequent Workout Wednesday participant Jack Hineman reached out to me last week saying he had just come up with something at work he thought would make a good WOW challenge. He sent it to me and it looked really interesting, so we’ve got a guest challenge this week. Here’s Jack: I have been debating
#WOW2026 | Week 10 | Baseline YoY Revenue Read More »
Introduction Welcome to Week 9 of 2026! This week, we’re going to explore using a form to bulk update multiple rows of an input table. As a bonus, we will also play with custom sorting controls. Good luck! -Ashley Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click
2026 Week 9 | Sigma: Do you ship it? Read More »
Introduction This week we’re going to build out a parallel coordinates chart – a type of visualisation used to display and compare multiple numerical measures. My daughter, Mia, is an academy level footballer and wears a stats vest in matches and training to capture lots of data about her performance. I’d been meaning to try
#WOW2026 | Week 9 | Can you build a parallel coordinates chart? Read More »
Introduction Welcome to week 9! I recently had a client reach out about some advanced navigation and filtering requests for their dashboard. It combined elements of Dynamic Zone Visibility and different types of filter actions. And I thought it was the perfect challenge for this week so here ya go! Click to open in Tableau
#WOW2026 week 8: DZV and Filter Actions Read More »
Introduction I’m so excited to introduce Forms to everyone – this feature is a key part of most data apps I build. They can help speed up development and maintain apps over time. So let’s dig in and see how forms can help us simplify actions and data apps. Need access to Sigma? Click Here to
2026 Week 08 | Sigma: Forms Read More »
Introduction This week’s Workout Wednesday challenge was Numbers of Different Magnitudes, but the bigger lesson for me was this: You can build custom analytical experiences in Sigma using AI. For this submission, I used AI-assisted coding to create a custom Sigma plugin (React + D3) that goes beyond standard chart behavior. It combines a magnitude view
2026 Week 07 | Sigma: Building a Custom Plugin with AI Read More »
Introduction Hello everyone, I’m very happy to be back for another year of Workout Wednesday! For my first challenge, I wanted to focus on something that every Tableau learner will encouter: Table Calculations and Level of Detail (LOD) Calculations, and what is the difference between them? Well, sometimes only one of these types of calculations
#WOW2026 | Week 7 | Exploring Table Calcs vs LODs Read More »
Introduction Did you know you can call Snowflake Cortex AI functions directly within Sigma? Sigma Workflow Conference in San Francisco is right around the corner, and we will build an AI Chatbot in a Sigma workbook to help users find answers to conference related questions. This AI App focused challenge will walk you through the
2026 Week 06 | Sigma: Can you build an AI Help Desk? Read More »
