Hi, I use a greehouse system and want calculate Daily light integral (DLI)

I must integrate the PPFD with different value during the day. All work well except the time I make my integral.

ON the left graph, I draw my PPFD with toronto time.

from(bucket: “borealis”)

|> range(start: v.timeRangeStart, stop: v.timeRangeStop)

|> filter(fn: (r) => r[“_measurement”] == “borealis”)

|> filter(fn: (r) => r[“_field”] == “LIGHT”)

|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)

|> yield(name: “mean”)

On the right, I calculate the DLI for each day.

THe problem is the 24h period is not the same. That causing the data is not good. I should do integral from 00:00 to 23:59. So it seem to be different and the 1day period is on different hour.

from(bucket: “borealis”)

|> range(start: v.timeRangeStart, stop: v.timeRangeStop)

|> filter(fn: (r) => r[“_measurement”] == “borealis”)

|> filter(fn: (r) => r[“_field”] == “LIGHT”)

|> aggregateWindow(

every: 1d,

fn: integral ,

createEmpty: false

)

|> map(fn: (r) => ({r with _value: r._value / 1000000.0}))

|> yield(name: “DLI”)

Any hints? thx Very much

INfo: It’s a continuity of this post: Integral function in FLuxQL - #4 by fredericgag