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 evolu...
Need Help
Tips and Tricks
  • AlenKovacevic's avatar
    AlenKovacevic
    5 years ago

    Hi Allison,

    Thanks that sounds like a good shortcut! 

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!