Hello All, simple question but still I have problem to realize it. there is table with “anomaly” field which has value 1 or 0. Now I need to perform percentage calculation how many anomaly with value=1 appears in relation to all anomalies (values 0 +1). So the idea is simple I need sum() / count…

hello @Tom999 , Yes! Sorry for the delay. Please feel free to tag me in the future. You could do something like: import "array" rows = [{_time: 1, _field: "foo", _value: 1}, {_time: 2, _field: "foo", _value: 0}, {_time: 3,_field: "foo", _value: 1}] data = array.from(rows: rows) total = (data …

Count() sum() on the same measurement

InfluxDB 2

Anaisdg October 7, 2022, 8:59pm 3

Also related to:

Topic		Replies	Views
InfluxQL count with subquery in Flux InfluxDB 2 flux	3	1313	December 14, 2020
How to calculate percentage given a condition InfluxQL	2	620	March 17, 2022
Get # of datapoints every hour in Flux InfluxDB 2	1	1114	December 8, 2020
Having Trouble Calculating Percentages	1	448	December 17, 2018
Calculate percentage using two queries InfluxDB 2 telegraf , grafana , query , flux	5	895	December 8, 2022

Count() sum() on the same measurement

Related Topics