September 2018
Intermediate to advanced
412 pages
11h 12m
English
book
Industrial Internet Application Development
by Alena Traukina, Jayant Thomas, Prashant Tyagi, Veera Kishore Reddipalli
Content preview from Industrial Internet Application Development
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Example – calculate the mean field value associated with a field key
The MEAN(*) function returns the arithmetic mean (average) of field values:
> SELECT MEAN("water_level") FROM "h2o_feet" name: h2o_feet time mean ---- ---- 1970-01-01T00:00:00Z 4.442107025822522
The output is the average field value for the water_level field key in the h2o_feet measurement.
For more examples and detailed information, go to https://docs.influxdata.com/influxdb/v1.2/query_language/functions/.