So one thing I did try was this: select time + 150s, mean(value) from "a_test_metric" where time > now() - 1h group by time(5m) but this give an error:
ERR: error parsing query: mixing aggregate and non-aggregate queries is not supported. On Friday, January 27, 2017 at 8:55:06 AM UTC-8, Travis Keep wrote: > > Question: > > Is there a way to configure how influx rolls up data for group by time(5m) > queries? For instance, tell influx to average the timestamps of each time > range instead of reporting the start timestamp of each range? > > Clarification: > > Currently if you add "group by time(5m)" Influx will average all the > values between 10:00 and 10:05 and report that average @ 10:00; then > average values between 10:05 and 10:10 and report that average @ 10:05. We > want influx to report the midpoint time rather than the start time so that > the average of values between 10:00 and 10:05 is reported @ 10:02:30, not > 10:00. Is this possible to do? > > > > > -- 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/bb67c09d-ec96-4dfb-94f1-f7594fb08e20%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
