Please could someone help me im tring to convert a Query from QL to flux and cant seem to get it right [WhatsApp Image 2022-04-01 at 14.51.49] [WhatsApp Image 2022-04-01 at 14.52.17] it is for it is taking a value and calculating to differance every hour to put in a bar graph. thank in advance …

[image] thanks for you help grant i think i got it using the derivative like in your example.

Have you tried building the Flux query in Influx Data Explorer? I usually have good success there and then copy/paste the query to Grafana.

Hi grant, yes ive done that in the notebook but i just cant seem to make the numbers match to to old QL from(bucket: “LawtonYarns”) |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == “EM3_Electrical_Workshop”) |> filter(fn: (r) => r["_field"] == “To…

When you build the above Flux query in Influx Data Explorer, do you see any output on the graph? dummy example: [image]

[image] think im just missing something with the time its working but the valuse are not the same as the old one im trying to get the differance between every hour of the 4 incrumenting values. its for kwh from a power meter measureing 3 phase and total.

What about in Influx Data Explorer? The URL would be http://<<your server>>:8086 That is where I will often build and test the query before trying it in Grafana.

[image] this is the right figures see the kwh

another quick question how do i give the data an alias like in QL ?

You can use a Transformation to rename the data to something else. If you do not know how, search the forum with my name and the word transformation and influx and it should show up someplace.

QL to Flux in a query

Grafana Configuration

tommy07900 April 4, 2022, 1:29pm 9

and this is what im getting in flux the pattern is the same just the numbers are out ???

Topic		Replies	Views
Flux query equivalent - power usage InfluxDB query-help , flux	1	1076	June 28, 2022
Transitioning from InfluxDB 1.x InfluxQL to 2.x Flux query language Grafana	5	10290	December 30, 2023
Convert Dashboard to use Flux query InfluxDB	0	407	January 21, 2021
Different graph between Flux and InfluxQL and Homeassistant History Time Series Panel	13	1083	May 16, 2023
Port a dashboard with InfuxQL query to Flux InfluxDB	3	1533	May 20, 2021

QL to Flux in a query

Related topics