Hello,
I am trying to combine stacking and grouping in a Bar Chart.
I have the following queries:
import "experimental"
import "date"
from(bucket: "proxmox-telegraf")
|> range(start: experimental.subDuration(d: 60m, from: v.timeRangeStart), stop: experimental.addDuration(d: 60m, to: v.timeRangeStop))
|> filter(fn: (r) => r["_measurement"] == "net")
|> filter(fn: (r) => r["_field"] == "bytes_recv" or r["_field"] == "bytes_sent")
|> filter(fn: (r) => r["interface"] == "eno1")
|> filter(fn: (r) => r["host"] == "pve")
|> aggregateWindow(every: 60m, period: 60m, fn: last, createEmpty: false)
|> difference(nonNegative: true, columns: ["_value"])
|> timeShift(duration: -1h, columns: ["_time"])
and
import "experimental"
import "date"
from(bucket: "opnsense-telegraf")
|> range(start: experimental.subDuration(d: 60m, from: v.timeRangeStart), stop: experimental.addDuration(d: 60m, to: v.timeRangeStop))
|> filter(fn: (r) => r["_measurement"] == "net")
|> filter(fn: (r) => r["_field"] == "bytes_recv" or r["_field"] == "bytes_sent")
|> filter(fn: (r) => r["interface"] == "ue0")
|> filter(fn: (r) => r["host"] == "OPNsense.localdomain")
|> aggregateWindow(every: 60m, period: 60m, fn: last, createEmpty: false)
|> difference(nonNegative: true, columns: ["_value"])
|> timeShift(duration: -1h, columns: ["_time"])
Currently I get either
Without stacking and
with stacking.
What I want is having two stacked bars, one per query, grouped per hour.
Does anyone have an idea how to achieve this?