i have a problem with the results of my flux query using the flux-funciton difference. When i selcect data from the whole year it returns wrong results at first of march (minus values) and doubles the values at the first of november. I have checked my data in influx db, the data are correct and there are no wrong entries in the db. The result are only wrong when both first of march and first of november are in the time range. Whe i use a time range where only first of march or first of november ist in the time range, the result is correct
Query:
import “timezone” option location = timezone.location(name: “America/Los_Angeles”)
from(bucket: “${BucketInflux}”)
|> range(start: ${__from:date}, stop: ${__to:date})
|> drop(columns: [“host”, “year”, “month”])
|> filter(fn: (r) => r._measurement == “power_boiler” )
|> difference()
|> aggregateWindow(every: ${Interval}, fn: sum)