Offset with Cumulative Sum

Get Help
1

Hello!

Is it possible to use CumulativeSum with offset?

For example if i have daily data and i want to see what my current cumulative revenue is, i can use cumulative sum. If i then went to compare that to the same date last year I was hoping to use Offset with -365

I get an error saying aggregations can’t be used with cumulative sum or something like that.

Is there any way around this?

2

Yes, you have to apply the offset first, then CumulativeSum the result. You have to do this in separate stages. You may have to write questions for the 2 time periods and join them on the day of the year or month, then sum the individual columns.

Can you give us an example of the input & output you want to achieve?