On Tuesday, August 23, 2016 at 9:12:21 AM UTC+5:30, [email protected] wrote: > Is it possible to perform GROUP BY aggregation across multiple measurements, > such that they can be selected into a new single measurement? > > For example, I'd like to do something like: > > SELECT COUNT(value) as h_count, SUM(value) as h_sum, MIN(value) as h_min, > MAX(value) as h_max INTO hourly FROM /rawdata.*/ GROUP BY time(1h), tag1, tag2 > > The result I'm seeing when I try this leads me to believe the aggregate > function isn't being applied across all the matched measurements -- just > within each. Is there a way to aggregate across all of them with InfluxQL? If > so, how? > > If not, I can probably work around this with a different schema, but it seems > like it'd be a useful thing to be able to do. > > Thanks, > Casey
HI casey, Were you able to perform aggregation with multiple measurements . Which one did you choose ?. Even i want to achieve similar kind of challenge. Thanks, Tejesh S -- 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/437c2e38-2b15-4b3f-8c05-df9060a1503c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
