I have a seemingly simple problem that I’ve been stuck on for hours. I have a counter and want to know by how much the counter increases per period and plot that in chronograf:
from(bucket: "volkszaehler") |> range(start: dashboardTime) |> filter(fn: (r) => r.title == "HcStarts") |> filter(fn: (r) => r._field == "value") |> aggregateWindow(every: 1d, fn: max) |> derivative(unit: 1d, nonNegative: true, columns: ["_value"])
Only I can’t use
max since its not an aggregate function. Trying to use derivative first and the sum inside the aggreagteWindow didn’t work either.
How would I do this?