Reply To: Moving Averages

August 8, 2017 at 4:34 pm #387
Bill Finzer
Keymaster

Hello Mitchell,

We don’t have a moving average function. (But I’m adding a feature request for one on your behalf.)

But if I’ve understood correctly, you can compute what you are after as follows.

  1. Create an attribute named runningSum with the formula prev(runningSum,0)+current
  2. Create an attribute named runningAvg with the formula runningAvg/caseIndex

Is this is the kind of average you’re looking for? When I tried it, I got a nice graph for three runs. Note that I had to define an attribute named ticks with the formula caseIndex.

Hope this helps,

Bill

Attachments:

  1. runningAvg.png