Hello, I’m running InfluxDB (Flux) as backend for Grafana. For the following data, how could I get new values for ratio of a_unicast/a_total, b_unicast/b_total, c_unicast/c_total… |_time | a_unicast | a_total | b_unicast | b_total | c_unicast | c_total | |t1 | 697420 | 10220494 | 5520780 | 55223…

Option 1: Using Flux’s map() function: |> map(fn: (r) => ({ r with a_ratio: float(v: r.a_unicast)/float(v: r.a_total), b_ratio: float(v: r.b_unicast)/float(v: r.b_total), c_ratio: float(v: r.c_unicast)/float(v: r.c_total) })) [Flux] Option 2: …

Hi ebabeshko, Yes, it will work for the known amount and names for the fields. But another challenge is that both the amount and names for the fields here are dynamic, except for the key word ‘_unicast’ and ‘_total’. For example, sometimes the table header will look as following instead. | kk_un…

that breaks the recommended and documented schema design standard by influxdb. those should be tags or field properties imo check this out [image] Summary and representation of daily to calendar monthly values InfluxDB MUST READ for schema design that will help reduce mem…

How to show ratio among multiple values - Flux

Grafana InfluxDB

yosiasz May 25, 2024, 3:16pm 4

that breaks the recommended and documented schema design standard by influxdb. those should be tags or field properties imo check this out

Topic		Replies	Views
Expression in stat, issues with dividing two different measures with influxql Dashboards	2	418	January 7, 2025
Correct value in Total row when field is calculation of ratio of two other fields Table Panel	3	451	April 24, 2024
Calculating (a bit special) ratio using Grafana transformations Dashboards value-mapping , transformations , panel	0	2176	August 11, 2022
Expression is not operated in grafana dashboard InfluxDB flux	1	266	October 18, 2024
Help needed: How to divide two value stream values InfluxDB query-help	1	672	December 19, 2022

How to show ratio among multiple values - Flux

Related topics