I used the following SQL query to display the hourly data. Why is the hour 0:00 to 1:00 not displayed. What do I have to change for that?
Where are the data of 0:00-1:00
SELECT non_negative_difference(last(cumulative_sum)) FROM(
SELECT cumulative_sum(non_negative_difference(last(“value”))) FROM “shellies/shellyem-HausSolar/emeter/0/total” WHERE $timeFilter GROUP BY time(1h)
) WHERE $timeFilter GROUP BY time(1h)
timeFilter is now-1d/d (Yesterday)
Query shows only 23 entry
The first Array is 1:00 ;o missing 0:00