cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud Waterfall Charts

charles_braybrook
Active Participant

Does anyone have any decent guides to waterfall charts? All the ones I've found have been pretty basic and doesn't talk about the requirements to getting them to work.

One of the many things that I'm struggling with is how we hide 0 values for them.

waterfall.png

I'm trying so that in the chart above it will create a bridge between Volume (CY) and Volume. (PY)

I've managed to get it vaguely working by creating restricted measures on each of the divisions for both Volume (CY) and Volume (PY) that would appear in the bridge and then creating a calculated measure to get the variance. This produces something like this:

waterfall-2.png

However, the problem is that this can't be interacted with. The divisions are the 2nd level in a hierarchy and ideally I would like to drill down to the lowest level in a division.

At the very least I need a way of hiding anything in the Waterfall chart that is 0.

Any help would be most welcome.

former_member997199
Discoverer
0 Kudos

Hi, I have a simple waterfall graph

measure = revenue

2 Dimensions = version & customer

Time is filtered dynamically to the month

For the version I use Actual and budget, customers being the waterfall effect.

The waterfall graph defaults to actual being bridged to budget. As my actuals are higher than budget, what should be an increase in customer revenue is being shown as negative. How can I flip to start with budget to show an increase in revenue?

Thanks

Former Member
0 Kudos

I saw your posted comment. Please raise a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. I suggest using the "I have a similar question" option under the question to get started. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Best,

Your SAP Community moderator

Accepted Solutions (0)

Answers (3)

Answers (3)

IngoH
Active Contributor

Hello Charles,

right now the option to use would be to have all those measures individually done in SAC (or already in BW) strating with the Volume CY.

hope this helps

Regards

Ingo Hilgefort, SAP

charles_braybrook
Active Participant
0 Kudos

Hi Ingo,

That is currently what I have been doing. However this then falls foul to the filtering not hiding "0" values.

I have a requirement to have waterfall chart of line items (18 or so) and then filter it by division. (3 division) However using this method will result in 6 bars showing values and 12 empty values.

Which needless to say is not acceptable.

Regards,

Charles

IngoH
Active Contributor

Hello Charles,

the data items - are those "0" or "null" ?

When you design the waterfall chart, did you use one more multiple measures ?

It sounds like you want to use the Volume CY as start, the Volume PY as End and use another dimension / hierarchy in between ?

thanks

Ingo Hilgefort, SAP

charles_braybrook
Active Participant
0 Kudos

Hi Ingo,

I believe they would come back as "0". In the example that I managed to get (sort of) working, I created a restricted measure for each dimension on Volume CY and PY. Then did a calculated measure to calculate the variance between the two restricted measure.

This calculated measure is what it is used in between the Volume CY and PY on either side.

Correct what I want is to have Volume CY as the start and Volume PY as the end and have a dimension hierarchy in the middle to show what makes up the difference between the two.

Thanks,

Charles

0 Kudos

dear all, is there a "guide" for complex waterfall charts? i have various requirment but donot know how to start:)