Migrate query to calculate energy (kWh)

You need to enable time zone support I would assume. You are in UTC days/months.

import "timezone"

option location = timezone.location(name: "America/Los_Angeles")

(Source: https://www.influxdata.com/blog/time-zones-in-flux/