Visokio Forums

OmarKhan · July 25, 2011 10:11AM

Rolling (dynamic) average function that accommodates multivariate conditions (last 52-week average)

steve · July 25, 2011 3:52PM

Do you mean a formula function, rather than a feature? If you mean the former, this might be achievable using SUBSET functions. If the latter, does moving average in the Graph view Line options help?

sherriff · February 12, 2012 6:33AM

I am having difficulty creating a rolling/dynamic/moving average/total using SUBSET functions.

I have attached a file with daily data and would like to create an annual moving total.
It would be greatly appreciated if someone could show me the best way to do it.

steve · February 14, 2012 7:42AM

See attached

sherriff · February 28, 2012 7:04AM

Steve, thank you for your solution to this. It is very much appreciated and will be used in our training program for all new staff.

Visokio Forums

Welcome!

Categories

Tagged