The timestamps are the beginning of the bucket, not the end. Therefore the "2016-11-06T00:00:00Z" value, 395890, is for the 2016-11-06 to 2016-11-13 time range.
On Thu, Nov 10, 2016 at 4:12 AM, <[email protected]> wrote: > Below query will get data from 2016-10-12T18:30:00Z and aggregated by week > ( sunday to sunday). > > SELECT SUM(value) FROM campaignstats WHERE event='sent' AND > channel='browser_push'And time >= '2016-10-12T18:30:00Z' GROUP BY time(1w > ,3d) fill(0) > > But Its not returning current week data. I run it today ( wednesday > 10-11-2016). data for 6th november to 13th november is missing.for example, > > [ > "2016-10-09T00:00:00Z", > 215935 > ], > [ > "2016-10-16T00:00:00Z", > 1197385 > ], > [ > "2016-10-23T00:00:00Z", > 1058452 > ], > [ > "2016-10-30T00:00:00Z", > 250785 > ], > [ > "2016-11-06T00:00:00Z", > 395890 > ] > > > > any idea why? Please help asap. > > thanks... > > -- > 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/3fd28b7c-9df5-45f8-bfd1-a6b105e98589%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvNJKTTa6tgmKM_0k8SegXjcE%2B%3D6nPSb4p%3D8oMZV5xcMiQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
