Hi all!
Having the same problem.
My query is:
SELECT integral(“value”) / 3600000 FROM “W” WHERE (“entity_id” = ‘active_energy_import_total’) AND $timeFilter GROUP BY time(1h) fill(null)
When the selected period is the whole day, there are a few hours with the wrong data.
But data is correct when I select that specific hour.
I even found a specific minute with this problem.
Whole day period result: 0.649
Specific hour result: 0,00268
The data in DB are:
|2022-04-13T11:54:00.000+03:00||
|2022-04-13T11:54:10.000+03:00|538|
|2022-04-13T11:54:20.000+03:00||
|2022-04-13T11:54:30.000+03:00||
|2022-04-13T11:54:40.000+03:00|0|
|2022-04-13T11:54:50.000+03:00||