There is no way to explicitly specify the number of points in the return. The fill clause can make sure each bucket has a value: https://docs.influxdata.com/influxdb/v0.13/query_language/data_exploration/#the-group-by-clause-and-fill
On Tue, Sep 6, 2016 at 3:09 PM, Mathias Herberts <[email protected] > wrote: > > > On Tuesday, September 6, 2016 at 9:44:17 PM UTC+2, Sean Beckett wrote: >> >> 48 hours / 20 points = 2.4 hours per point = 144 minutes: >> >> SELECT MEAN(temperature) FROM measurement WHERE time > now() - 2d GROUP >> BY time(144m) >> > > If the actual data does not cover the total interval this will lead to > less than 20 datapoints, is there a way to specify that the datapoints > should be grouped in such a way as to produce 20 results regardless of the > first and last timestamps of the original data? > > >> >> On Tue, Sep 6, 2016 at 11:22 AM, Michael Reed <[email protected]> wrote: >> >>> I am logging temperature at 15 minute increments, and wish to chart the >>> temperature between two dates. Instead of charting thousands of data >>> points, I wish to reduce the data between the two dates to 20 points where >>> each of these points is the average for its time interval. The two dates >>> will be at least 24 hours apart. >>> >>> How can this be accomplished? >>> >>> Thank you >>> >>> -- >>> Remember to include the InfluxDB version number with all issue reports >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "InfluxDB" 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/ms >>> gid/influxdb/c0e60924-91b8-451b-8380-7e1971119165%40googlegroups.com >>> <https://groups.google.com/d/msgid/influxdb/c0e60924-91b8-451b-8380-7e1971119165%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sean Beckett >> Director of Support and Professional Services >> InfluxDB >> > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/514663c0-606c-4ed1-911e-2179064d7d2e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/514663c0-606c-4ed1-911e-2179064d7d2e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvPWcuCHbBmnE6W7To%3DPd9ge3xBBDyKWapDcyjfuqFdqUA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
