How to combine stacking and grouping in a Bar Chart

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?