Hi,
I am running a tickscript to down sample / sum my data per hour for further use related to some analytics activites related to my energy consumption.
Tickscript looks like this:
batch
|query('SELECT sum(kWh) as total FROM "iotawatt"."autogen".l2l3kwh')
.period(1h)
.every(1h)
.groupBy(1h)
|influxDBOut()
.database('analytics')
.retentionPolicy('autogen')
.measurement('kwhperhour')
.precision('s')
I though the above script would sum all my values and group by hour, but when I compare the output towards my original data there is a clear mismatch.
I assume there is something in my tickscript that is not correct. Any ideas?