Hello, I’m new to Flux, and I’m trying to calculate monthly power data (kilowatt hours). I’ve got this query which works in InfluxQL, but doesn’t allow grouping of data monthly which Flux allegedly does. SELECT integral("value", 1h) / 1000 FROM "power" WHERE $timeFilter GROUP BY time(1d,12) fill(…

Can you provide the some of the output from: from(bucket: "iotaWatt/autogen") |> range(start: -180d) |> filter(fn: (r) => r._measurement == "grid" and r._field == "value" )

For example: #datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,double,string,string #group,false,false,true,true,false,false,true,true #default,_result,,,,,,, ,result,table,_start,_stop,_time,_value,_field,_measurement ,,0,2019-11-03T03:10:22.947788477Z,2020-05-01T03:10:22.94…

Hmm, I wonder if Flux is truncating the response because of its size and Grafana doesn’t have a way to display that only partial results are returned. With points every 5 seconds, your query is likely returning, then aggregating approximately 3.1 million points. Although you should still get results…

Why do you try to calculate monthly consumption from a database that has points for every 5 seconds in time? Build a continuous query that downsamples your data into 1h chunks and calculate your monthly consumption from that measurement.

Hi @mabnz did you resolve your issue? I need similar solution. I have evey 5 seconds recorded current power consumption and I need to build “electricity meter” in Flux. Daily and Monthly and Year to date total consumption.

Scott’s code worked great for me, although I left off the last line as I want to first create hourly data. (I will also integrate to daily and monthly The only thing missing is changing the units label from Watts to kWh in the output

Can anyone show the working Code?

Hello @Anaisdg , I am currently switching from InfluxDB 1 to Version 2. At the moment I am sending the data from the electricity meter to both databases. In Grafana, I have already successfully visualized the data from V1. At the same time, I am now working on visualizing the data from V2 in Grafan…

Hello @Cavekeeper , It might be timezones in which case you’ll want to look into using: timezone.location() function | Flux 0.x Documentation timezone.location() returns a location record based on a location or timezone name. Or timezone.fixed() fu…

Migrate query to calculate energy (kWh)

Fluxlang

pawelgl May 9, 2022, 4:49am 29

Hi,
try add "timeSrc: “_start” to last aggregateWindow like:
|> aggregateWindow(fn: sum, every: 1d, timeSrc: “_start”)

Multiple aggregation windows for power aggregation

Topic		Replies	Views
Multiple aggregation windows for power aggregation Fluxlang	10	2189	July 17, 2022
Flux: Get total energy by month with an ever-increasing value InfluxDB 2 influxdb , time-series , grafana , query , flux	8	4999	January 18, 2023
Multiply two field values and store the result in a new field	22	11901	June 9, 2020
Flux: 3phase network - actual power consumtion to actual energy consumption (slow & day shift +1) InfluxDB 2 influxdb , grafana , flux	4	495	January 18, 2023
Flux: Monthly values of data that represents a total value Fluxlang time-series , query , flux	11	1451	March 19, 2023

Migrate query to calculate energy (kWh)

Related topics