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 15 – Bivariant Maps Read More »
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 10 – DuBois Challenge 01 Read More »
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 05 – Case SLAs Read More »
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
2024 Week 01 – Leap Years Read More »
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
Meet the new CRMA contributors! Read More »
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 45 | Pareto Charts Read More »
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 43 | Sea Ice Extend Read More »
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 39 | Timeline Gantt Chart Read More »
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 35 | Timeline dot plot Read More »
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 31 | Customised Tooltips Read More »
