On Tuesday, January 10, 2017 at 5:42:04 PM UTC-5, Matthew Guindin wrote: > I’m trying to downsample data on a weekly basis and am hitting a problem with > the time range it's apparently running against. > I have a continuous query that looks like this: > > > CREATE CONTINUOUS QUERY weekly_data_cq ON db > BEGIN > SELECT sum(count) as sum, last(*) > INTO db.one_month.weekly_data > FROM db.autogen.daily_data > GROUP BY id, time(1w) > END > > > The data that's being recorded to `weekly_data` seems inconsistent somehow > based on the day of the week this is run. Am I misunderstanding something > with the database? > When this runs today, it’s producing data for the week starting today and > ending on the 17th, not from the 3rd to the 10th as I figured it would run. > > > I haven’t found documentation or examples using this large of a window since > the documentation is using hours or minutes, so I’m not sure if this is a bug > or if I’m not using the DB properly. > > > -Matt
I forgot one additional part, the Continuous Query is running `RESAMPLE EVERY 30m FOR 1w` -- 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/dcdd18a3-cade-4bca-9000-7f86fc95ffca%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
