I’m using 2 panels, one of which uses the results from the first. When used in a repeating row, the second panel does not make proper use of the variable that’s being calculated.
Here is the Flux query:
intInfo = from(bucket: "${dataSource}")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "interface")
|> filter(fn: (r) => r["friendlyname"] == "${NetInterface}")
|> distinct(column: "friendlyname")
|> keep(columns: ["name"])
|> rename(columns: {name: "interface"})
netStats =
from(bucket: "pfsense_201")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "net")
|> filter(fn: (r) => r["_field"] == "bytes_recv" or r["_field"] == "bytes_sent")
|> derivative(unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time")
join(
tables: {netStats: netStats, intInfo: intInfo},
on: ["interface"],
)
And here is what is happening.
As you can see, the second row is showing the proper data in the first panel, but not the second.