Different Integral results by changing time Range

[antonio79]

Thanks @grant2!

This seems to be influxdb here. Can this be implemented in the DB environment of the Grafana plugin?

influxDB Subquery not working

Hi, 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 $tim…