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.

Reply via email to