Tagged with moving_averages - Visokio Forums

Subset formula: 7 Day Moving Average calculation

mttwnxn — Mon, 30 Jan 2017 13:06:59 -0500

Hi - I was wondering if anyone could help. What would be the best way to calculate a running average over a moving 7 day window? I want to use this to help create a simple forecast to determine, at the current rate, what would be the closing position position be at the end of the current week or month. Essentially answering questions such as: "if my spend over the past 7 days is maintained, how many ad impressions would I have delivered in February 2017"

My data would be structured simply as below:

Date | Market | Campaign | Channel | Impressions | Clicks | Spend
01/01/17 | UK | ABC | ABC | 111 | 111 | 1111

Formulae: Rolling (dynamic) moving average

OmarKhan — Mon, 25 Jul 2011 10:11:09 -0400

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

Formulae: Calculating 12-month Moving Average from daily data?

nitiwan — Mon, 18 Aug 2014 04:16:06 -0400

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...Tai

Formulae: Moving averages for daily data?

nash — Wed, 23 Jul 2014 03:33:59 -0400

My data have KPIs on a daily basis for every day of the week.

I would like to calculate the average of the KPIs for 3, 7, 10, 14 days from the starting date in the data.

Thanks.

Formulae: Moving Average on the previous row's result?

Oke369 — Wed, 23 Apr 2014 11:11:58 -0400

Good day
Please can you assist, basically I have attached 3 files, Automation Excel, I am trying to replicate this formula on Omniscope. if you look at k17 the formula is a moving average, then in cell k18 the formula changes by referencing cell k17 and then Adding a few variables.

In stock I've added a few of my failed attempts at the formula, I would just like clarity on where I'm going wrong. I manage to get the first 3 results. correct but then it seems to loop?
Please let me know if you need anything else.
thank you, Stephen

Formulae: Calculating moving averages?

joemako — Wed, 02 May 2012 19:31:17 -0400

If I want to get a moving average for ten records in a formula field added into a Field Organiser block in DataManager, is there an easier way than something like:

SUBSET_SUM([Value],SUBSET2([Row],[Row],([Row]-10),[Row], ">", "<="))/10...where in the previous operation, the function CURRENTROW() populates the [Row] field?