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.
