My photovoltaics Daily-Yield is stored in influxdb.
I now wanted to visualize the yields in longer time ranges, for example weeks or month.
Since I think this isn’t possible without a subquery, I tried it this way.
The Subquery is getting the latest daily-yield data of every day, the main query is summing this daily yield data to the longer timerange, in this example weeks:
SELECT SUM("value") FROM (SELECT LAST("value") FROM "mqtt_consumer" WHERE ("topic" = 'home/garden/test3') AND $timeFilter GROUP BY time(1d) fill(null)) WHERE $timeFilter GROUP BY time(1w) fill(null)
Unfortunately, his query doesn’t reply any data.
Does anyone have an idea what’s wrong in this query? I can’t find my mistake(s)…