# Alex Waleczek

## 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 …

## 2023 Week 27 | Slopechart

Introduction If you spent any time working with charts, you are probably aware of the controversy around pie charts. While there are some aspects to be discussed, others are generally agreed upon. One of these ones is the fact that it’s next to iimpossible to compare the slices of two pies with each other. Nevertheless, …

## 2023 Week 23 | Sales Funnels

Introduction There are a lot of visualisation common practises that are less than ideal. One of those is the funnel chart. I think the analogy works well, however a lot of implementations are misleading at best. Unfortunately the default funnel chart in CRMA belongs in that category. As the value is only encoded in the …

Scroll to Top