Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
No, in an Analysis, each row or line is calculated separately (as it can be multi-threaded). So you cannot use window functions in an Analysis.
You should use a SQL, Python or R recipe to do that.
(Similarly to the sorting.)
We have on the roadmap a Window recipe (similar to the Grouping recipe) that will work on datasets managed by SQL databases supporting such functions (PostgreSQL, etc.).
I hope that helps,