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 …
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 …
Introduction Maps, maps, and maps. We all love them, after all, in an era where data drives decision-making across industries, the significance of map charts cannot be overstated. From tracking global trends to uncovering localized patterns, these visualizations serve as powerful navigational aids in our quest for understanding. Following our trend of past challenges, this …
2024 Week 12 | CRM Analytics: Brazil’s opportunities dashboard 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 …
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 In this workout, we received weather data from weather machine, where every hour degree are stored in a column, and degree for each area are represented as a row. To easily work on this data, we need to transpose the data from column to row. sample source data Requirements Create a dev org or use an …
Introduction It’s already week 7 of our #WorkoutWednesday challenges (whoa, time flies…). In this challenge, I’d like to explore one aspect of the column multi-selection interaction in CRM Analytics: sorting. When we select more than 1 grouping, can we maintain the sorting within the selected groups, regardless of the selection’s order? We’ll find out in …
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 …
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 …
Introduction 2024 is here! And with that, a completely new set of challenges for you, data lover. Let’s sharpen our CRMA skills with this challenge: A double bar chart displaying open and closed amounts by account. The closed amount should display won and lost amounts in a single stacked bar. The open amount should be …
