Trailing Twelve Months

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 πŸ”΅

    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"