SQL transforms LAG or LEAD


I tried LAG function in mySQL transform, but it appered to be missing.  Is this correct?


  • jaeW_at_Onyx

    Domo uses MySQL 5.6+

    @VERSION for the exact version number.


    This version of MySQL predates the implementation of Windowed functions.


    You can recreate it using user defined variables.



    Without performance tuning in MySQL, you'll probably get faster performance using MagicETL if you start using larger datasets.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

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

    If you create a Redshift transform instead of SQL, you can use LAG.  I was shown how to create a Redshift dataflow to get active clients by month using start and end date on the client record. 

This discussion has been closed.