meekey

Comments

...also, I don't see LAG in my list of available functions... Sorry for such basic questions, Grant. Thanks for your help :)

in How do I calculate the average of the past 3 sales of an item? Comment by meekey July 2022
I see so many examples of lag functions that all reference a date, so since I don't care about date necessarily, do I just leave end it with over ()? (lag((sale_price),1) over( ) + lag((sale_price),2) over( ) + lag((sale_price),3) over( ) + )/3

in How do I calculate the average of the past 3 sales of an item? Comment by meekey July 2022