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 in a separate bar beside the closed amount. The tooltip should display the total closed amount, total open amount and the individual won and lost values.
Requirements
- Create a dev org or use an existing org you have access to
- Upload the dataset attached to this challenge.
- Calculate
- The won amount
- The lost amount
- The total closed amount
- The total open amount
- Insert these calculations in the tooltip
- Sort the bart by won amount, descending
The resulting chart should look something like this:
Tips: You’ll need SAQL
Dataset
Share
After you finish your workout, share a screenshot of your solutions or interesting insights.
Either on Twitter using the hashtags #WOW2024 and #CRMA and tag @genetis, @PreenzJ, @LaGMills and @msayantani. (Or you can use this handy link to do that)
Or on LinkedIn, tagging Alex Waleczek, Preena Johansen, Lauren Mills, Sayantani Mitra and Phillip Schrijnemaekers using the hashtags #WOW2024
Also make sure to fill out the Submission Tracker to track your progress and help us judge the difficulty of our challenges.