Introduction Last week the challenge was how to create a quasi-histogram in CRM Analytics. Here is my solution, hope you guys like it. If you used a different solution, share it with us in the comments. Solution Let’s start by getting any numeric value from our dataset. You can upload your dataset. I am using …
Introduction Hello again, everyone. One of the things that CRM Analytics misses in its variety of charts is a histogram. A histogram is a chart that displays the frequency (count) of rows within a range of numeric values. For example: you have opportunity records with several amounts (2500,3000,5000.8750.10000, etc). In a histogram, we’d create a …
Introduction Hello again, everyone. As data analysts, we are frequently asked to present the “Top N” group members sorted by a metric. In this blog, we’ll try to bring the top 4 accounts industries sorted by count, and group all the following members in a single “Other” bar below the top 4 ones. Requirements Create …
Introduction Hey guys! Welcome back to a new challenge!! One of the things I like the most about CRMA is how easy is to customize and make the dashboard dynamic and flexible, to display the data we want. In this challenge , let’s build a chart using 3 different datasets, and use the interactions of …
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 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 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 …
