Are you asking for how to get SUM(MEAN(value))? Use CQs to perform the inner function, then use the outer function on that new data.
https://docs.influxdata.com/influxdb/v1.0/query_language/continuous_queries/#substituting-for-nested-functions On Thu, Oct 27, 2016 at 2:15 AM, <[email protected]> wrote: > 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 > > -- > 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/1cdac910-6a48-4e6a-8863-e9d9ac7e8ef4%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvMFJENo0Kk1vHTkt1efEwh8rsTg_jjYES03M-KSvTJyHw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
