Larry, CQs support the GROUP BY time offset <https://docs.influxdata.com/influxdb/v1.0/query_language/data_exploration/#configured-group-by-time-boundaries> parameter now that #7025 <https://github.com/influxdata/influxdb/issues/7025> is fixed. To timeshift to local midnight, use this CQ:
SELECT sum(field1) INTO db.custdaily FROM db.msrmt1 GROUP BY time(1d*, 4h*) Note that this is NOT timezone sensitive. That means that when the offset from UTC changes back to +5 for EST, the CQ will need to be updated. On Fri, Sep 16, 2016 at 10:28 AM, 'Larry Walker' via InfluxDB < influxdb@googlegroups.com> wrote: > How to shift the time so this happens at midnight local time. > > > [continuous_querier] 2016/09/15 20:04:17 executing continuous query > custdaily (2016-09-14 20:00:00 -0400 EDT to 2016-09-15 20:00:00 -0400 EDT) > > [query] 2016/09/15 20:04:17 SELECT sum(field1) INTO db.custdaily FROM > db.msrmt1 WHERE time >= '2016-09-15T00:00:00Z' AND time < > '2016-09-16T00:00:00Z' GROUP BY time(1d) > > > Seems strange to create a daily 9/13, 9/14, 9/15 graph all these values > for where the values are 8pm to 8pm which spans multiple days. > > -- > 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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/6a3eba6d-182e-4141-8e82-9b5fd5dea02e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/6a3eba6d-182e-4141-8e82-9b5fd5dea02e%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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvNWoXMciTtnH2BU6bXKu7kKdw79Ogcym2vbDRB-ZjbxXQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
