ERR: invalid operation: time and *influxql.BinaryExpr are not compatible

basking-in-the-sun2000 / solar-logger

A datalogger for a solar inverter. Stores data in influxdb and displays it in grafana. Has load diverting capability, to use the inverter's excess power

GNU General Public License v3.0

97 stars 31 forks source link

ERR: invalid operation: time and *influxql.BinaryExpr are not compatible #22

Closed WMP closed 2 years ago

WMP commented 2 years ago

Query:

select cumulative_sum(diff)  as "∑ balance" from (SELECT first("P_Exp") - first("P_Grid") + first("Adj") as diff FROM "Huawei_daily" WHERE time > '${__to:date:YYYY-MM-18}' - 52w  GROUP BY time(1d) fill(0));

on influxd 1.8.1-1 (ubuntu 20.04) return this error: ERR: invalid operation: time and *influxql.BinaryExpr are not compatible

I think that this same error is describe here: https://discourse.nodered.org/t/value-calculation-last-day/42419

WMP commented 2 years ago

Upgrade grafana to version 8 fix this problem.

basking-in-the-sun2000 commented 2 years ago

@WMP :) glad you got it fixed. The ${__to: date:YYYY-MM-18} is internal to grafana and not used by influx. Didn't realize it was a recent change, and you needed version 8.

Actually, this is going to disappear. Turns out that it doesn't show the actual balance after a while. At least on net-metering, it shows the cumulative sum of the past year, but not your current energy balance. The new method should deduce the months you didn't have excess from those you did before. Hopefully will be ready soon.