Calculate Power Consumption on defined Periode with TAGS

, ,
1

Hello Team,

I hope you’ll be able to help me, because I’m completely confused about getting the right calculation.

I’d like to know the electricity power consumption of my equipment per day by mode. Okay, that sounds basic, but…

The context: Every 10 seconds, my equipment provides the cumulative energy counter info and the consumption mode. The consumption mode is a tag (see my extract file and the query below).

Because the mode can change multiple times during the day, I’m unable to use a simple difference calculation, and I don’t know how to build my query.

I need to calculate the consumption by mode period and cumulate the value per day (e.g., I’ve consumed X kW for COOL mode and Y kW for FAN_ONLY mode).
That’s something I don’t know how to do.

Thanks a lot for your support on it.

Franck

Basic Query to extract my data and to show the data structure

from(bucket: "ElecConso")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ConsoPAC")
  |> filter(fn: (r) => r["_field"] == "Cum_PAC")
  |> filter(fn: (r) => r["Mode"] == "OFF" or r["Mode"] == "HEAT" or r["Mode"] == "FAN_ONLY" or r["Mode"] == "COOL" or r["Mode"] == "DRY")

The file of data for exemple
query.csv.txt (1.8 MB)

2

Hi @Franck_Bellot

Did not have a chance to test this, but I think it may get you closer:

from(bucket: "ElecConso")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ConsoPAC")
  |> filter(fn: (r) => r["_field"] == "Cum_PAC")
  |> filter(fn: (r) => r["Mode"] == "OFF" or r["Mode"] == "HEAT" or r["Mode"] == "FAN_ONLY" or r["Mode"] == "COOL" or r["Mode"] == "DRY")
  |> group(columns: ["Mode"])
  |> aggregateWindow(every: 1d, fn: (tables) => 
      tables
        |> sort(columns: ["_time"])
        |> difference(nonNegative: true)
        |> sum()
    , createEmpty: false)
  |> yield(name: "daily_consumption_by_mode")
3

Hello grant1

This will not work because I can get multiple periode mode in the same day, difference will provide wrong result.
I need to identify each mode periode and calculate difference for each mode periode but I do not know how to do it.
Of course as soon as periodes calculation are accomplished, need to do a sum by day
Hope my explanations are getting more good input to find the solution

4

Oops, sorry, I misunderstood the problem. If you have multiple modes running on the same day (e.g., switching from HEAT to COOL to OFF), calculating the difference on the cumulative value across different modes will give incorrect results.

Try this instead:

from(bucket: "ElecConso")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ConsoPAC")
  |> filter(fn: (r) => r["_field"] == "Cum_PAC")
  |> filter(fn: (r) => r["Mode"] == "OFF" or r["Mode"] == "HEAT" or r["Mode"] == "FAN_ONLY" or r["Mode"] == "COOL" or r["Mode"] == "DRY")
  |> sort(columns: ["_time"])
  |> group(columns: ["Mode"])  
  |> difference(nonNegative: true, columns: ["_value"])  
  |> aggregateWindow(every: 1d, fn: sum, createEmpty: false)
  |> yield(name: "daily_consumption_by_mode")