Grafana Heatmap Panel - Network Fabric Utilization

heatmap_panel.json

{
  "id": 2,
  "type": "heatmap",
  "title": "Network Fabric Utilization",
  "description": "",
  "gridPos": {
    "x": 0,
    "y": 0,
    "h": 13,
    "w": 14
  },
  "fieldConfig": {
    "defaults": {
      "custom": {
        "scaleDistribution": {
          "type": "linear"
        },
        "hideFrom": {
          "tooltip": false,
          "viz": false,
          "legend": false
        }
      }
    },
    "overrides": []
  },
  "pluginVersion": "11.6.0",
  "targets": [
    {
      "datasource": {
        "type": "influxdb",
        "uid": "000000003"
      },
      "groupBy": [
        {
          "params": [
            "1m"
          ],
          "type": "time"
        },
        {
          "params": [
            "ifName"
          ],
          "type": "tag"
        },
        {
          "params": [
            "source"
          ],
          "type": "tag"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "IF",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          },
          {
            "params": [
              "1s"
            ],
            "type": "derivative"
          },
          {
            "params": [
              "*8/1000000000"
            ],
            "type": "math"
          }
        ]
      ],
      "tags": [
        {
          "key": "source",
          "operator": "=~",
          "value": "/spine/"
        },
        {
          "condition": "AND",
          "key": "ifName",
          "operator": "!~",
          "value": "/\\./"
        }
      ]
    }
  ],
  "datasource": {
    "uid": "eekyccqhjr01sf",
    "type": "influxdb"
  },
  "options": {
    "calculate": true,
    "yAxis": {
      "axisPlacement": "left",
      "reverse": false,
      "unit": "percent"
    },
    "rowsFrame": {
      "layout": "auto"
    },
    "color": {
      "mode": "scheme",
      "fill": "dark-orange",
      "scale": "exponential",
      "exponent": 0.5,
      "scheme": "RdYlBu",
      "steps": 128,
      "reverse": false,
      "min": 0
    },
    "cellGap": 1,
    "filterValues": {
      "le": 1e-9
    },
    "tooltip": {
      "mode": "single",
      "yHistogram": false,
      "showColorScale": false
    },
    "legend": {
      "show": false
    },
    "exemplars": {
      "color": "rgba(255,0,255,0.7)"
    },
    "calculation": {
      "xBuckets": {
        "value": "1m",
        "mode": "size"
      },
      "yBuckets": {
        "value": "0.5"
      }
    }
  }
}

Using InfluxDB1 / InfluxQL as DataSource, measurement IF.
FROM "IF" WHERE ("source" =~ /spine/ AND "ifName" !~ /\./) to include only Spine interfaces and exclude Subinterfaces.