Grafana/pfSense Monthly data usage panel

{
  "datasource": "InfluxDB - Jersey/telegraf",
  "fieldConfig": {
    "defaults": {
      "custom": {},
      "unit": "decbytes",
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "semi-dark-green",
            "value": null
          }
        ]
      },
      "mappings": []
    },
    "overrides": []
  },
  "gridPos": {
    "h": 6,
    "w": 3,
    "x": 11,
    "y": 3
  },
  "id": 33,
  "links": [],
  "options": {
    "reduceOptions": {
      "values": false,
      "calcs": [
        "lastNotNull"
      ]
    },
    "orientation": "horizontal",
    "colorMode": "background",
    "graphMode": "none",
    "justifyMode": "auto"
  },
  "pluginVersion": "7.0.0",
  "targets": [
    {
      "alias": "In",
      "groupBy": [],
      "measurement": "snmp",
      "orderByTime": "ASC",
      "policy": "default",
      "query": "SELECT last(\"ifHCInOctets\") - first(\"ifHCInOctets\") AS \"in\" FROM \"snmp\" WHERE (\"hostname\" = 'ROTO.beyerfamily.us' AND \"ifName\" = 'bce0') AND $timeFilter\n\n",
      "rawQuery": true,
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "first"
          },
          {
            "params": [
              "in"
            ],
            "type": "alias"
          }
        ],
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "last"
          },
          {
            "params": [
              "out"
            ],
            "type": "alias"
          }
        ]
      ],
      "tags": [
        {
          "key": "hostname",
          "operator": "=",
          "value": "ROTO.beyerfamily.us"
        },
        {
          "condition": "AND",
          "key": "ifName",
          "operator": "=",
          "value": "bce0"
        }
      ]
    },
    {
      "alias": "Out",
      "groupBy": [],
      "measurement": "snmp",
      "orderByTime": "ASC",
      "policy": "default",
      "query": "SELECT last(\"ifHCOutOctets\") - first(\"ifHCOutOctets\") AS \"out\" FROM \"snmp\" WHERE (\"hostname\" = 'ROTO.beyerfamily.us' AND \"ifName\" = 'bce0') AND $timeFilter\n",
      "rawQuery": true,
      "refId": "B",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "first"
          },
          {
            "params": [
              "in"
            ],
            "type": "alias"
          }
        ],
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "last"
          },
          {
            "params": [
              "out"
            ],
            "type": "alias"
          }
        ]
      ],
      "tags": [
        {
          "key": "hostname",
          "operator": "=",
          "value": "ROTO.beyerfamily.us"
        },
        {
          "condition": "AND",
          "key": "ifName",
          "operator": "=",
          "value": "bce0"
        }
      ]
    }
  ],
  "timeFrom": "30d",
  "type": "stat",
  "cacheTimeout": null,
  "timeShift": null,
  "title": ""
}