1

Waterfall Chart to show the actual growth split by category

We need to build a waterfall chart that shows the LY Sales as the first bar, then shows the Actual Growth split by category, then shows the resulting CY Sales figure.

Does anyone have a creative idea on how to get this result?
 

Thanks,

Natalie

3 replies

null
    • Let me connect you
    • Community_chris
    • 3 mths ago
    • Reported - view

    Hi Natalie,

    this looks a lot like the IBCS Charts that were introduced last year. Would that do the trick? https://community.pyramidanalytics.com/t/g9hvpf9/dashboard-gallery-business-modeling
    and here is the Tip&Trick for it: https://community.pyramidanalytics.com/t/83yh4t5/how-to-build-visualization-according-to-the-ibcs-standard

      • Principal Customer Solutions Consultant
      • Mark_Oldfield.1
      • 3 mths ago
      • Official response
      • Reported - view

        this approach fits the use case perfectly. The IBCS Waterfall chart uses 2 value fields for the waterfall, a 'from' and a 'to'. In your use-case you will put CY Sales in the 'Values' drop zone (for the 'to') and LY Sales in the 'Additional Values' (for the 'from' value), you can then put the dimension attribute you wish to waterfall in the 'Categories' drop zone.

       

    • NatalieAnne_Botha
    • 3 mths ago
    • Reported - view

    Thanks Mark and Christian for the feedback - we are upgrading our server soon so really looking forward to this new functionality.

Content aside

  • Status Answered
  • 1 Likes
  • 3 mths agoLast active
  • 3Replies
  • 59Views
  • 3 Following