Hi,
Im trying to provide a single percentage figure in a dashboard that shows the Week on Week percentage change in two totals. Right now I’ve got the following query:
lastweek = from(bucket: v.bucket)
|> range(start: -14d, stop: -7d)
|> filter(fn: (r) => r["_measurement"] == "api_call")
|> filter(fn: (r) => r["_field"] == "request_count")
|> drop(columns: ["organisation", "organisation_id", "type", "project", "project_id"])
|> sum()
thisweek = from(bucket: v.bucket)
|> range(start: -7d, stop: now())
|> filter(fn: (r) => r["_measurement"] == "api_call")
|> filter(fn: (r) => r["_field"] == "request_count")
|> drop(columns: ["organisation", "organisation_id", "type", "project", "project_id"])
|> sum()
union(tables: [lastweek, thisweek])
And this gives me two rows with the 2 weeks of totals, but I can’t figure out how to then create a percentage change of these 2 values.
My result table currently looks like the following:
