The alternative to a difference function to build a waterfall

Question & 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?

#3

Hi @Przemk00,

I recommend that you share a sample dataset. It will help the community answer more accurately with examples that matches your dataset schema. How do you represent the periods - do you use a date?