search

beufanet / linkyndle

Fetch dataset from Enedis portal (need Linky) and push it to grafana
53 stars 15 forks source link

Fix timezone issue on 'Power Consumption Values per day' #12

Closed roumano closed 5 years ago

roumano commented 5 years ago

In influxDB data are store in UTC time so the group by time(1d) is grouping with a 2h of shift It's was possible to use something like :

SELECT sum(\"value\") FROM \"conso_elec\" WHERE $timeFilter GROUP BY time(1d,-2h) fill(null)

But look like less portable than specify the TimeZone ( tz('Europe/Paris') )