Hello @Anaisdg,
my query is:
from(bucket: “host_db/autogen”)
|> range(start: dashboardTime)
|> filter(fn: (r) => r._measurement == “fve” and (r._field == “e”) and r.fve == “1” )
|> window(every: 1mo, period: 1mo)
|> spread()
|> map(fn: (r) => ({ r with _value: r._value / 1000.0 }))
And the result:
I should state that unfortunately, the result is wrong as expected:
the feature of year/month duration grouping is still under development as can be seen at feat(values): add month support when adding durations to a time value by jsternberg · Pull Request #2067 · influxdata/flux · GitHub
