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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/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. For more options, visit https://groups.google.com/d/optout.
