Aggregate Integral Function

[gesquive]

A function we use often in graphite is integral. It's pretty self explanitory. We really want to completely replace graphite with influxdb and this would really help our case.

[balistof]

Provide also an aggreate Integral Average function. So that you not take the Mean (sum of values divided by count) but instead use the time as the weight. Basically like Integral but dividing the Integral value by the group by time() range.

[C4ptainCrunch]

Any update on this ?

[martinpallmann]

I also like to know if there is happening something regarding this ticket. We're using influx right know and the missing integral function is a big problem for us.

[beckettsean]

@martinpallmann it is not yet scheduled for a particular release, so it is 6+ weeks away. Watch this issue for updates to the Milestone. That's out backlog.

[michaelsproul]

I've implemented an integration aggregation function in #3344 and would appreciate feedback and help getting it merged 😄

[hotsnow77]

+1

[enavarro222]

+1
This will be very useful to get energy consumption (Kwh) from power logging (W)

[markusr]

@enavarro222
We use: SELECT sum(power)/count(power) FROM "data" WHERE $timeFilter GROUP BY time(1h)
to calculate the energy consumption in [Wh]. power is [W]

[carlosandroni]

@markusr
Your solution is just like using MEAN function and works only if you have a fixed sample time.

[pakozm]

I'm also interested in this feature... Is it planed to be introduced in InfluxDB?

[oluies]

+1

[sischnei]

+1: Would allow to count the amount of events processed!!

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

[lukecyca]

+1

[lbuchy]

+1

[JarrettR]

+1

[uprial]

+1

[dstreppa]

+1

[lukyad]

+1

[dongshu2013]

+1

[staehler]

+1

[hurtstotouchfire]

+1

[AndreJacomeSilva]

+1

[stettix]

+1

[bkdspanning]

+1

[jwasys]

+1

[elphick]

+1

[tnn24]

+1

[t-pfaff]

+1

[villaRob]

+1

[StasGoshtein]

+1

[micbuh]

+1

[ultima-originem]

+1

[hl68fx]

+1

[cantino]

+1

Has anyone found a workaround for this? I need this for calculating power use with a variable power sampling rate, as mentioned by @enavarro222 and @carlosandroni.

Edit: it looks like #8194 has been merged. How do I determine which version of influxdb will support this?

[JarrettR]

https://github.com/influxdata/influxdb/blob/master/CHANGELOG.md

Looks like it's in 1.3.0 (Still unreleased)

[popey456963]

It has since been released, this issue should probably be closed?

It would be useful to update the documentation here

[suikast42]

+1