influxQuery for "1 before last" to get full window data

[Anaisdg]

@Richtation,
Thanks for sharing your solution!
For future reference to anyone else inquiring there are these two examples of candlestick functions

OHLC (open-high-low-close) Function

Aggregate to multiple results from one input

@lexchou You have a few options. You can only join two streams at a time, but you can do multiple joins: data = from(bucket: "dcoin") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "btcusdt" and (r._field == "price")) open = data |> aggregateWindow(every: v.windowPeriod, fn: first, createEmpty: false) high = data |> aggregateWindow(every: v.windowPeriod, fn: max, createEmpty: false) low = data |> aggregateWindow(every: v.windowPeriod, fn:…