Influxdb: Aggregate Integral Function
gesquive
All 38 comments
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.
balistof
on 18 Feb 2015
Any update on this ?
C4ptainCrunch
on 4 Jun 2015
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.
martinpallmann
on 8 Jul 2015
@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.
beckettsean
on 9 Jul 2015
I've implemented an integration aggregation function in #3344 and would appreciate feedback and help getting it merged :smile:
michaelsproul
on 16 Jul 2015
+1
hotsnow77
on 3 Aug 2015
+1
This will be very useful to get energy consumption (Kwh) from power logging (W)
enavarro222
on 7 Sep 2015
@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]
markusr
on 8 Sep 2015
@markusr
Your solution is just like using MEAN function and works only if you have a fixed sample time.
carlosandroni
on 5 Oct 2015
I'm also interested in this feature... Is it planed to be introduced in InfluxDB?
pakozm
on 16 Dec 2015
+1
oluies
on 20 Feb 2016
+1: Would allow to count the amount of events processed!!
sischnei
on 23 Feb 2016
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.
beckettsean
on 18 Mar 2016
+1
lukecyca
on 29 Mar 2016
+1
lbuchy
on 4 May 2016
+1
JarrettR
on 4 May 2016
+1
uprial
on 21 Jun 2016
+1
dstreppa
on 8 Jul 2016
+1
lukyad
on 8 Jul 2016
+1
dongshu2013
on 9 Jul 2016
+1
staehler
on 13 Jul 2016
+1
hurtstotouchfire
on 20 Jul 2016
+1
AndreJacomeSilva
on 16 Sep 2016
+1
stettix
on 22 Sep 2016
+1
bkdspanning
on 23 Sep 2016
+1
jwasys
on 1 Nov 2016
+1
Elphick
on 15 Nov 2016
+1
tnn24
on 11 Jan 2017
+1
t-pfaff
on 10 Feb 2017
+1
villaRob
on 25 Feb 2017
+1
StasGoshtein
on 20 Mar 2017
+1
micbuh
on 30 Mar 2017
+1
ot3
on 23 Apr 2017
+1
hl68fx
on 26 Apr 2017
+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 https://github.com/influxdata/influxdb/pull/8194 has been merged. How do I determine which version of influxdb will support this?
cantino
on 18 May 2017
https://github.com/influxdata/influxdb/blob/master/CHANGELOG.md
Looks like it's in 1.3.0 (Still unreleased)
JarrettR
on 18 May 2017
It has since been released, this issue should probably be closed?
It would be useful to update the documentation here
popey456963
on 15 Oct 2017
+1
suikast42
on 23 Apr 2018
Related issues
dtouzeau
路
3Comments
ricco24
路
3Comments
Raniz85
路
3Comments
jonira
路
4Comments
jayannah
路
3Comments
Most helpful comment
+1
This will be very useful to get energy consumption (Kwh) from power logging (W)