Windowed functions in Magic ETL 2.0

dacorson
dacorson ⚪️
in Data Platform & Data Science

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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories