Hello, I am receiving each five minutes energy data with a 1 minute frequency. I wanted to group by 15 min data using the average. For example I have the following data: 2016-12-16T02:01:00.000Z 34.398992 2016-12-16T02:02:00.000Z 34.154403 2016-12-16T02:03:00.000Z 33.981884 2016-12-16T02:04:00.000Z 33.774041 2016-12-16T02:05:00.000Z 33.594796 2016-12-16T02:06:00.000Z 33.474959 2016-12-16T02:07:00.000Z 33.009581 2016-12-16T02:08:00.000Z 32.899283 2016-12-16T02:09:00.000Z 32.760757 2016-12-16T02:10:00.000Z 32.756765 2016-12-16T02:11:00.000Z 32.436273 2016-12-16T02:12:00.000Z 32.22376 2016-12-16T02:13:00.000Z 32.01422 2016-12-16T02:14:00.000Z 31.697213 2016-12-16T02:15:00.000Z 31.683289 2016-12-16T02:16:00.000Z 31.696565 2016-12-16T02:17:00.000Z 31.73662 2016-12-16T02:18:00.000Z 31.75104 2016-12-16T02:19:00.000Z 31.68634 2016-12-16T02:20:00.000Z 31.754498 2016-12-16T02:21:00.000Z 31.969857 2016-12-16T02:22:00.000Z 32.167043 2016-12-16T02:23:00.000Z 32.477415 2016-12-16T02:24:00.000Z 32.538236 2016-12-16T02:25:00.000Z 32.643691 2016-12-16T02:26:00.000Z 32.646297 2016-12-16T02:27:00.000Z 32.661518 2016-12-16T02:28:00.000Z 32.658084 2016-12-16T02:29:00.000Z 32.672899 2016-12-16T02:30:00.000Z 32.763996 I would like to get: at the timestamp: 2016-12-16T02:15:00.000Z the average value of the data from 2016-12-16T02:01:00.000Z to 2016-12-16T02:15:00.000Z at the timestamp: 2016-12-16T02:30:00.000Z the average value of the data from 2016-12-16T02:16:00.000Z to 2016-12-16T02:30:00.000Z ...
For that I tried to use the continuous query as follow: CREATE CONTINUOUS QUERY sumrealproduction ON FMV_calcul RESAMPLE EVERY 15m for 30m BEGIN SELECT ... GROUP BY time(15m) END As I undersand with the doc if I add an offset (GROUP BY time(15m,15m), it will not do what I expect. 1)Is there an other way to do what I expect? -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/5a451f25-5853-499f-813e-cc317041b3ed%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
