I have one year's worth of sales data, and I'd like to calculate the cumulative sales total, enabling me to analyze the total sales made up to a specific date.
You can fulfill the aforementioned requirement by utilizing a window aggregate function through Window Aggregation Node, enabling you to compute the running total of sales. Moreover, you can also calculate the cumulative total within each category by leveraging partition fields.
Hello Namjoo,
You can fulfill the aforementioned requirement by utilizing a window aggregate function through Window Aggregation Node, enabling you to compute the running total of sales. Moreover, you can also calculate the cumulative total within each category by leveraging partition fields.
Configuration Window: