2024 Week 03 – Double bar amount by accounts


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.


  • 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 file


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.


Coming later..
Scroll to Top