YTD Formulas
ian-martin
Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 2 ✭
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?
Best Answer
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,124 Neuron
For cumulative sums you can use the Window Recipe:
For YTD you can set the Partition to a column with the Year and Order to your Date column.