Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Sign Up
Learn more
I am having issues trying to create a column that outputs the year-to-date sum of another column. I am not sure if there is a formula that can be applied in the prepare recipe. Has anyone been able to replicate a YTD Column before?
For cumulative sums you can use the Window Recipe:
https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/tutorial-window-recipe-deep-div...
For YTD you can set the Partition to a column with the Year and Order to your Date column.
never-displayed
