Re: [influxdb] Aggregating samples when interval in GROUP BY time() is not the same as metric resolution

Hi Sean, On Monday, September 12, 2016 at 12:04:27 PM UTC-7, Sean Beckett wrote: > Maybe you meant to give this as the query? > > > SELECT sum(value) FROM online_users WHERE region='xyz' AND time > NOW() - 1d > GROUP BY time(1m) You're completely right - yes, I inadvertently left out the

[influxdb] Re: Aggregating samples when interval in GROUP BY time() is not the same as metric resolution

Running 1.0 and Grafana 3.1.1. -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to

[influxdb] Aggregating samples when interval in GROUP BY time() is not the same as metric resolution

Hi, I think the answer to this question is "use CQ", but it seems like an obvious use case so maybe I've overlooked a better solution: I have series collected every minute detailing the number of users per service per region. Let's say the measurement is called online_users with tags service