Hello,
Anyone can help me please? Thank you! Le vendredi 16 décembre 2016 08:51:28 UTC+1, wug a écrit : > > 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? > > > > Le vendredi 16 décembre 2016 08:51:28 UTC+1, wug a écrit : > > 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? > > > > Le vendredi 16 décembre 2016 08:51:28 UTC+1, wug a écrit : > > 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? > > > > Le vendredi 16 décembre 2016 08:51:28 UTC+1, wug a écrit : > > 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? > > > > Le vendredi 16 décembre 2016 08:51:28 UTC+1, wug a écrit : > > 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/c3385297-a1f7-4541-8e42-b7ee9502ca2f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
