I want to know what is the difference between Time sum and moving sum.
Scenarios that we use them individually
Hi @143kishornaidu ,
Timesum : It is being used to summing up data for certain period of time for example you need a sum of data from particularly March to June then you can use Timesum to aggregate that. Secondly it is also used to aggregate data from a time dimension module to a without time dimension module.
Movingsum : It is a forecasting method based on aggregation of last few months. It can only be used in the modules with Time dimension.
Hope this helped!
So technically everything that MOVINGSUM does, can be done by TIMESUM, but the problem is, TIMESUM has worse performance. If you have some time, you can check this lighthearted 10-minute video about strengths and differences between these two functions: https://www.youtube.com/watch?v=PvimWuX5jVw