Joining of device metrics

  • What Grafana version and what operating system are you using?
    Grafana 10.0.3

  • What are you trying to achieve?
    By default, if I graph a metric, Grafana display info on all devices. For example, the ‘io_wait’ metric, it’ll graph all disks. I really just want an overall value for all disks. Same with Network stats, it’ll show ‘err_in’ for all network interfaces.

  • How are you trying to achieve it?
    from(bucket: “InfluxBucket”)
    |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
    |> filter(fn: (r) => r[“_measurement”] == “diskio”)
    |> filter(fn: (r) => r[“_field”] == “io_time”)
    |> filter(fn: (r) => r[“host”] == “${host}”)
    |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
    |> yield(name: “sum”)

  • What happened?
    result auto show ‘io_wait’ for sda, sdb, sdc, etc.

  • What did you expect to happen?
    Just one ‘io_wait’ value

  • Can you copy/paste the configuration(s) that you are having problems with?
    Query above

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors

  • Did you follow any online instructions? If so, what is the URL?
    Multiple articles about joining transform options, none helped.

Welcome @bsoileau to the Grafana forum. I cannot completely understand the issue you are having. You wrote:

Do you mean a total value, for example like this:

BEFORE:

AFTER: