Waterfall Chart to show the actual growth split by category

NatalieAnne_Botha
3 mths ago
3replies
Answered

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

waterfall

- 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.