Calculate Growth Rate and Average Growth Rate for Absolute Values

InfluxDB 2 Dashboards
,
1

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

CleanShot 2023-09-05 at 19.52.38@2x
CleanShot 2023-09-05 at 19.52.38@2x1026×836 52.3 KB

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.