Trailing Twelve Months

naterust
naterust
in Archive

I want to add a column to an existing data set that gives me trailing twelve months (TTM) of the amounts instead of just that day. Is there a way to do that in ETL?

Comments

  • AS
    AS Coach

    Have you checked out the new Rank & Window transform (under edit columns) in ETL yet?  This might have what you're looking for.

    https://knowledge.domo.com/?cid=etlactionsrankandwindow

     

    The details might be tricky based on your data, but you'd likely use the SUM function in that transform over a certain number (or all) of your preceding rows.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories