Calculate Growth Rate and Average Growth Rate for Absolute Values

Hey there!

I am new to writing InfluxDB queries and tried calculating the relative growth for a series of absolute values and the average of these rates.

Here is what I’d like the outcome to look like

Here is the query for the totals

from(bucket: "data")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "stats")
  |> filter(fn: (r) => r["_field"] == "points")

I tried the “difference” function but failed to get the results shown in the screenshot.

I appreciate any hints! Thanks.