Hello I am having some difficulty with the flux language(completely new to it), I am pulling some data from ethermine.org and want to display it in grafana. I have the following measurements and fields that are applicable: measurement name is my_metric-ethermine and the 2 field names are “unpaid”, …

Ok, you should just be able to fill those null values with the previous values. Try this: from(bucket: "altus") |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r._measurement == "my_metric-ethermine" and r._field == "unpaid" or r._field == "price_usd" or r._…

[image] Altus: |> map(fn: (r) => ({ r with _field: unpaid / 10e17 * price_usd }) I think _field might be the issue, should probably be _value. Docs provide this in one of the examples map(fn: (r) => ({ _value: r._value * r._value })) map() function | Flux Documentation …

I tried this: but get that error [image]

Just found this old post- it’s not exactly what you’ve described but it’s close. [image] Multiply two field values and store the result in a new field @samdanisms If you don’t need to store the values, the Flux will work. Grafana supports Flux: Flux (InfluxDB) [BETA] plu…

Thanks, i’ll have a look at it when I get data to go into influxdb again…added some stuff to my python script and suddenly data just stopped being sent :grimacing: :sweat_smile:

@Altus Try this: from(bucket: "altus") |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r._measurement == "my_metric-ethermine" and r._field == "unpaid" or r._field == "price_usd" ) |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") …

will do once I get my data back into influxdb…it broke and I’m not able to fix it :grimacing: Not sure what happened

Sorry that I’m only getting back now…managed to semi fix my data, have at least identified the piece of code that causes everything to break. I copied your code and got an error: invalid: error @10:27-10:30: undefined identifier e17 Edit: it works if I type the raw number ie 1000000000000000000.0

Oh right :man_facepalming:, Flux doesn’t support scientific notation float values.

haha no worries, thx for the help :slight_smile:

Hey scott, sorry to bother again, but it seems to have stopped working ( the same number has been displayed for the past day without changing). It was working until yesterday(will attach some screenshots to help explain). 1st screenshot has all 3 fields in and seems that only 1 value is non-zero i…

Flux Doing Transforms on Multiple Fields

Fluxlang

FixTestRepeat March 2, 2021, 10:01am 4

Just found this old post- it’s not exactly what you’ve described but it’s close.

Topic		Replies	Views
Multiply two field values and store the result in a new field	21	11977	June 8, 2020
Can't emulate a simple query from mysql in flux (calculating extra column) Fluxlang influxdb , grafana , flux	7	1341	August 3, 2022
Trying to migrate influxql to flux InfluxDB 2	49	5174	August 30, 2021
Join in flux. No results InfluxDB 2 flux	12	1891	May 24, 2022
Migrate query to calculate energy (kWh) Fluxlang influxdb , flux	30	12692	July 4, 2023

Flux Doing Transforms on Multiple Fields

Related topics