Should support moving averages aggregate function

[pauldix]

Should be able to calculate moving averages of different types. Simple, weighted, exponential, etc. Need to come up with specific syntax and stuff, but for now there's more reading here http://en.wikipedia.org/wiki/Moving_average

[nichdiekuh]

👍 EMA functions would be great!

[jvshahid]

Comments from #396 (which is a duplicate of this issue)

It would be great to have Influx calculate a (simple) moving average (or median, or maybe even percentiles).

For example: SELECT movingAverage(value, $window) FROM my_series, where $window could be a number of points/events, or a time interval, like 1s or 2m.

[spatil]

+1

[huhongbo]

+1

[clkao]

+1

[sahilthapar]

+1

[rmihael]

+1

[selbyk]

+1

[ybogdanov]

+1

[shaharke]

+1

[smartynov]

+1, really need this. Should we think about it together?

[mchmarny]

+1 but as a downsampled continuous queries

select mavg(val) from temp_series group by time(1h) into temp_series.mavg.1h

[DarrenMowat]

+1

[ajcrowe]

+1

[probepark]

+1

[pbrit]

+1

[tbillet]

+1

[naneau]

+1

[ebereketoglu]

+1

[tcolgate]

I'd really like to have a go at this (and Holt winters forecasting). CQ seems the right way of doing these. They'd need access previous buckets/periods. Any tips would be appreciated. I'll start having a dig around

[cemo]

+1

[mbalkanloo]

unsubscribe
On Mar 1, 2016 11:24 AM, "Julien Maitrehenry" notifications@github.com
wrote:

+1

—
Reply to this email directly or view it on GitHub
#77 (comment).

[thegreatjerboa]

+1

[mbalkanloo]

unsubscribe

On Wed, Mar 2, 2016 at 3:49 PM, Jeff Schumacher notifications@github.com
wrote:

+1

—
Reply to this email directly or view it on GitHub
#77 (comment).

[pauldix]

@mbalkanloo that's not how you unsubscribe to an issue. You're adding more noise whenever you send that email. Follow the link to GH and unsubscribe to the issue using their interface.

[hailpam]

+1

[tomazbracic]

+1

[beckettsean]

As mentioned in my post to the mailing list we are experimenting with simplifying our open GitHub Issues. This feature request has been rolled into an aggregate issue for all function requests, so that we can close this issue until we are ready to work on it.

You may continue to make comments here. Closing the issue does not mean we are rejecting this idea.

[jsternberg]

I'll be making a new issue for each component of this issue. The simple moving average aggregate is in #6112 and we hope to be able to get that into 0.12.0, but no promises.

I'm reclosing this issue for now.

[k3gk3gk3g]

+1

[szymic1]

+1

[blanet]

+1

[shawafts]

+1

[dterg]

+1

[alrghods]

+1

[vincentbarat]

+1

[jsternberg]

We have implemented some moving average functions. If you need a moving average function that isn't included in the latest version, please open a new issue so we can triage the issue.

Thanks. I'm going to lock this conversation to prevent additional +1 comments.