I have a query:
from(bucket: "journal_test") |> range( start: -70d ) |> filter(fn: (r) => r._field == "amount") |> window(every: autoInterval) |> keep(columns: ["_value", "_time", "_field"]) |> cumulativeSum()
it provides a cumulative sum for each data point which can be then charted. I’d like to define custom operation (e.g. sum of multiplicated two fields but probably bit more complex operation over 3-4 fields). Ideally something like
reduce() just need to output partial result for each point.