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
Count values for percentage Fluxlang grafana , flux	2	501	July 8, 2021
InfluxQL count with subquery in Flux InfluxDB 2 flux	3	1394	December 14, 2020
Flux Query to count unique occurrences of fields InfluxDB 2 influxdb	4	2074	April 24, 2023
Flux piping intermediate results Welcome & Getting Started	1	11	September 26, 2024
Flux Assistance - Divide Two Integrals Fluxlang grafana , flux	5	1222	January 6, 2022

Count() sum() on the same measurement

Related topics