Hello I have the same problem I think.
The single queries are ok but the combined one give no result, any suggestion?
SELECT (non_negative_derivative(mean(“POWERPANNELLI”), 120s )- non_negative_derivative(mean(“POWERCASA”), 120s ))
AS “Consumo”
FROM (
SELECT mean(“ENERGY_Power”) AS “POWERCASA” FROM “telegraf”.“autogen”.“CASA” WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY time(1m)
), (
SELECT mean(“ENERGY_Power”) AS “POWERPANNELLI” FROM “telegraf”.“autogen”.“Pannelli” WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY time(1m)
)
GROUP BY time(1m) fill(null)
