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.