# Alex Waleczek

## 2024 Week 15 – Bivariant Maps

Introduction Here is a fun one to keep the map theme going: Bivariant maps! These maps are a good way to encode two variables on a map and give the user a way to see the relationship between the two at a glance. But beware, correlation does not imply causation. So, while for this map …

## 2024 Week 10 – DuBois Challenge 01

Introduction Every February for a few years, a group of data viz enthusiasts kicks of the DuBois challenge, where the community is tasked with recreating some of W.E.B. Du Bois’ famous visualisations. I used our #WorkoutWednesday last year to participate and I intend to continue this (very short) tradition this year. Today we are looking …

## 2024 Week 05 – Case SLAs

Introduction This week we dive into date calculations in SAQL! Unlike other languages, SAWL doesn’t have a simple DATEADD() function. Instead we need to build one ourselves in order to be able to add days to a given date.  In this example we have case records with an Open Date, a Close Date and an …

## 2024 Week 01 – Leap Years

Introduction Happy new year and welcome to 2024! We have new contributors and a few ideas for this year, if you haven’t seen it already, you can find the announcement here. In case you haven’t noticed yet, this year is a leap year so this weeks challenge aims at identifying those in CRMA. It is …

## Meet the new CRMA contributors!

The first year of the CRMA #WorkoutWednesday challenges is over and we had a little bit of a shuffle in contributors. Huge thanks to Jack Parry for his contributions; between work and family, he couldn’t dedicate as much time as he wanted. For the new year we have two new contributors and if you have …

## 2023 Week 45 | Pareto Charts

Introduction You probably have heard of the Pareto Principle before. And if not under that name, you might have heard of the 80:20 rule which states that for many use cases, 20% of the input create 80% of the output. For example, for many projects 20% of the work is required to get you 80% …

## 2023 Week 43 | Sea Ice Extend

Introduction For this week’s #WorkoutWednesday we’ll recreated one of the PowerBI challenges from earlier in the year. In week 30, Shannon created a visualisation of sea ice extend in the Antarctic. Initially I thought this would be a rather easy challenge in CRMA but I ended up with a few tricky nuts to crack. Requirements …

## 2023 Week 39 | Timeline Gantt Chart

Introduction As promised, this challenge is a continuation of my last challenge in week 3. The source data stays the same just this time we convert the chart into a kind of Gantt. While the dot plot highlighted the points in time when the stage of the opportunity changed, this chart focusses a bit more …

## 2023 Week 35 | Timeline dot plot

Introduction One of the inciting factors for the CRMA WorkoutWednesday was this collaborative Tableau challenge last year. I attempted it in CRMA and actually got quite far. This week we’ll try something similar, with the hopes to be able to build on it for my next challenge in a couple of weeks. (We’ll see how …

## 2023 Week 31 | Customised Tooltips

Introduction Salesforce recently introduced the ability to customise tooltips a lot more than before. Just adding values however quickly becomes a bit boring. We already looked into viz in tooltips in Week 03 and now we will extend the concept a bit further. In this particular use case I have a chart that shows all …

Scroll to Top