The alternative to a difference function to build a waterfall

Question and answer
, , ,
#1

Hi guys,

I am trying to make a calculated field which will be pretty much the “difference” function which will include T-0 period in order to build yearly results waterfall.

image
image1401×98 9.01 KB

Nevertheless, I failed. I tried nearly every function with “period” but without success.

The one which, perhaps, can solve is the periodOverPeriod() - but I am unable run it all. Hence, I can not find anything related to this function.

Alternatively, ifelse() with a difference but there’s no way to mix aggregate with non-aggregate functions.

Any tips?

#2

Thanks for reporting this issue. We will need more information to dive deep into the actual problem and identify solution. Please contact us via quicksight-help@amazon.com so that we can work with you on this more directly.