Hi there, when trying to make a rolling window summing the variable though the timeseries till a continuously growing number, the rolling window just turns the last variables number, and not the sum!
If using the sum function of the same variable on the dashboard it is possible to make a correct sum, but as this cannot be extracted to a derived calculation, it would be nice if the rolling window could calculate the sum for all time of a given variable though all time!
Or, else is this possible to do in derived function, and if so, what is the syntext?
Sum(“VARIABLE”, “M”) seems not to work e.g. should return the variable over a month if I look at you documentation! Not sure if the works for “Education”?
Please help!/Best Regards, Klaus