Moving Values One Row Down - Conversion Rates

keeeirs10

Hello! Does anyone know how to move the "Stage Count" column down one row (Stage Count 2) rather than erasing the top value? I am trying to get the Stage Count 2 column to read:

blank

3821

336

122

33

32

I attempted a LAG, but this version of mysql is too old to use I believe :(

Thanks,

Keirsten

MarkSnodgrass

@keeeirs10 Domo's MySQL is currently on version 5.6, which doesn't support lag. I would suggest using Magic ETL and using the rank & window tile and use the lag function in there. It will run very fast and is easy to put together. Here's the KB article on the rank & window tile if you haven't seen it.

https://domohelp.domo.com/hc/en-us/articles/360044876094-New-Magic-ETL-Tiles-Aggregate#3.