Hey i have seen a lot of open issues regarding missing time query functions for current/last month/year and so on in influxdb.
Now using flux there are date functions
I thought i could use them to get only results for the current month with this query:
import "date" month = date.monthDay(t: now()) from(bucket: "piMeter") |> range(start: month*(-1)) |> filter(fn: (r) => r._measurement == "downsampled_energy" and r._field == "sum_Gesamt") |> fill(value: 0.0) |> aggregateWindow(every: 1d, fn:sum)
but this gives me 18k results starting in 1970. Looks like the range gets not processed. Setting month variable manually to say -3 ends up with the same result.
Am i missing something here?