How to make LAG function work?
The Add Formula column modal shows that Lag, Lead, etc. window functions are available.
When I try to add the formula as lag( MAX("Date"), 1), it gives this error:
Please use aggregate formula option to create aggregate formula.
How do I use this function? Please update your documentation with detailed information and examples.