Forum Discussion

AlenKovacevic's avatar
AlenKovacevic
New Member
5 years ago
Solved

Add LTM figures to waterfall chart

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!

Need Help
Tips and Tricks

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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's avatar
      AlenKovacevic
      New Member
      5 years ago

      Hi Allison,

      Thanks that sounds like a good shortcut!