Op donderdag 27 oktober 2016 10:15:34 UTC+2 schreef [email protected]: > Hi all, > > Let's say we have a measurement "storage/free" which has a tag "host" and I > want to have a single value which shows summarized value of free space among > all hosts. > > If I run this I get average among all hosts: > SELECT mean("value") FROM "storage/free" WHERE time > now() - 1d GROUP BY > time(1d) > > If I run this I get multiple values (one per host) as a result: > SELECT mean("value") FROM "storage/free" WHERE time > now() - 1d GROUP BY > time(1d), host > > Could anybody tell me if it is possible to get a single value which would be > the sum for all hosts? > > Regards, > Stanislav
Hey, Not sure if this could be a solution. It's the first thing to come to my mind. Switch the group by order. So instead of : GROUP BY time(1d), host try GROUP BY host, time(1d) I hope this will solve your problem -- 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/be0bcd0a-db3f-4ed7-91eb-8afb17e791d4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
