Hey i have a time series which returns a value every 15-60 minutes.
Now i want to fill every Minute in between a value and the subsequent value with the previous value.
After calling my data i tried to achive this with the aggregateWindow() function or with the fill() function. Both options didn’t work.
My time series looks like this:
What i want to achive is something similiar to this:
The query i used was the following:
|> range(start: 2021-01-01T00:00:00Z)
|> filter(fn: (r) =>
r._measurement == “myMeasurement” and
r.short == “Status”
fn: (column, tables=<-) => tables |>fill(column: “_value”, usePrevious: true),
Could you please help me?