Add LTM figures to waterfall chart

[AlenKovacevic]

Hi everyone,

I would like to add LTM (Last Twelve Months) figures to a waterfall chart. I basically have sales data from 2018 until June 2021. What I would like to do is to show the channel evolution (B2B, B2C, E-commerce) per year. That's quite straightforward when you display data from 2018 to 2020. But when you display 2021 as well, it seems like 2021 is not performing well compared to previous years but it's just because it has 6 months in it instead of 12.

Therefore, is there a way to display 2018, 2019, 2020 and LTM21? Or that's way too complex?

Many thanks!

[AllisonKennedy]

@AlenKovacevic It might work ok if you do LTM for all years and put a filter on the visual to only show the last 5 years data so that the 2021 LTM is from today and not a future date. 

Do you already have the LTM measure? Use DATESINPERIOD or something similar

[AlenKovacevic · Accepted solution]

Hi Allison,

Thanks that sounds like a good shortcut!