Formulae: Calculating 12-month Moving Average from daily data?
-
If we have volume (orders) everyday about 20-30 orders per day, what is the best way to calculate moving average for 12 months? Are there any automated function or we have to write a formula?
Thanks so much...TaiAttachments
Daily data.xlsx 9K -
2 Comments
-
Tai - Moving averages are usually calculated using SUBSET function syntax. See examples here:
http://forums.visokio.com/discussions/tagged/moving_averages
This discussion has been closed.
← All Discussions Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.