What is the difference between Time sum and Moving SUm

143kishornaidu

I want to know what is the difference between Time sum and moving sum.

Scenarios that we use them individually

Accepted answers

All comments

ArnabG

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!

Thanks,

Arnab

M.Kierepka

Hi @143kishornaidu,

MOVINGSUM: for obtaining a time range of data directly relative to the target period. Both source and target should have the same time dimensions. You specify the range using the relative number of periods. Very useful for calculating rolling sums, averages, maxes and mins, or checking if in the last/next few months there is ANY/ALL condition true (on booleans), or some text value is present. So when you need the answer/result in every period of your report/output.
TIMESUM: for obtaining a time range of data not directly relative to the target period. Should really only be used when the target module is not using the same time dimension as the source (or no time dimension at all). You can specify the range using the relative number of periods or exact date/period. It's really useful when you have some module without time (or on higher level) where you need to calculate something based on absolute start and end, like when user selects from when to when they want to calculate something and report doesn't need to have time dimension.

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

Quick Links

Can you help?

Unanswered questions

Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
ADO Module Saved View does not exist Error
Hi, I’m experiencing a strange issue in ADO that I can’t seem to resolve. Before reaching out to Anaplan Support, I thought I would check with the community for advice. I’m trying to extract some list properties for an ADO mapping from a Polaris model/module. However, no matter what I do, I keep encountering the same error…