Windowed functions in Magic ETL 2.0

dacorson
dacorson βšͺ️

Does anyone know how to apply a dynamic range for windowed functions using SUM in Magic ETL 2.0? I would like to use another column value with the beginning range date in the range, but Magic ETL only allows static values.

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    You can create additional columns based on date calculations to get the range you want and then filter to that range and then use the rank and window tile to do your window functions.

    If you provide more details as to what you are doing, I might be able to provide a more specific solution.