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 …

Also related to: [image] Count values for percentage Fluxlang I want to create a panel in grafana but I am not able to get the exact data even from Influxdb itself. I have some jenkins pipelines and I want first to count them all and then the ones that are successful in o…

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	530	July 8, 2021
Calculate percentage using two queries InfluxDB 2 telegraf , grafana , query , flux	5	1178	December 8, 2022
Calculate % based on data (Influxdb 1.2)	1	1772	August 8, 2017
FluxQL query with percentage calculation for table with time on columns Fluxlang influxdb , flux	2	379	August 2, 2023
Having Trouble Calculating Percentages	1	498	December 17, 2018

Count() sum() on the same measurement

Related topics