Grafana/pfSense Daily data usage graph panel

{
  "aliasColors": {},
  "bars": true,
  "dashLength": 10,
  "datasource": "InfluxDB - Jersey/telegraf",
  "fieldConfig": {
    "defaults": {
      "custom": {}
    },
    "overrides": []
  },
  "fill": 1,
  "gridPos": {
    "h": 7,
    "w": 10,
    "x": 14,
    "y": 14
  },
  "id": 26,
  "legend": {
    "avg": false,
    "current": false,
    "max": false,
    "min": false,
    "show": true,
    "total": false,
    "values": false
  },
  "linewidth": 1,
  "links": [],
  "nullPointMode": "null",
  "options": {
    "dataLinks": []
  },
  "pluginVersion": "6.7.3",
  "pointradius": 2,
  "renderer": "flot",
  "seriesOverrides": [],
  "spaceLength": 10,
  "targets": [
    {
      "alias": "$tag_ifDescr $col",
      "groupBy": [
        {
          "params": [
            "1d"
          ],
          "type": "time"
        },
        {
          "params": [
            "ifDescr"
          ],
          "type": "tag"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "snmp",
      "orderByTime": "ASC",
      "policy": "default",
      "query": "SELECT non_negative_derivative(last(\"ifHCInOctets\"), 1d) AS \"in\", non_negative_derivative(last(\"ifHCOutOctets\"), 1d) *-1 AS \"out\" FROM \"snmp\" WHERE (\"hostname\" = 'ROTO' AND \"ifName\" = 'bce0') AND $timeFilter GROUP BY time(1d), \"ifDescr\" fill(null)",
      "rawQuery": true,
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "ifHCInOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "last"
          },
          {
            "params": [
              "1d"
            ],
            "type": "non_negative_derivative"
          },
          {
            "params": [
              "in"
            ],
            "type": "alias"
          }
        ],
        [
          {
            "params": [
              "ifHCOutOctets"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "last"
          },
          {
            "params": [
              "1d"
            ],
            "type": "non_negative_derivative"
          },
          {
            "params": [
              "*-1"
            ],
            "type": "math"
          },
          {
            "params": [
              "out"
            ],
            "type": "alias"
          }
        ]
      ],
      "tags": [
        {
          "key": "hostname",
          "operator": "=",
          "value": "ROTO"
        },
        {
          "condition": "AND",
          "key": "ifName",
          "operator": "=",
          "value": "bce0"
        }
      ]
    }
  ],
  "thresholds": [],
  "timeFrom": "30d",
  "timeRegions": [],
  "title": "Daily WAN usage",
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "type": "graph",
  "xaxis": {
    "buckets": null,
    "mode": "time",
    "name": null,
    "show": true,
    "values": []
  },
  "yaxes": [
    {
      "$$hashKey": "object:3058",
      "format": "decbytes",
      "label": null,
      "logBase": 1,
      "max": null,
      "min": null,
      "show": true
    },
    {
      "$$hashKey": "object:3059",
      "format": "short",
      "label": null,
      "logBase": 1,
      "max": null,
      "min": null,
      "show": false
    }
  ],
  "yaxis": {
    "align": false,
    "alignLevel": null
  },
  "cacheTimeout": null,
  "dashes": false,
  "fillGradient": 0,
  "hiddenSeries": false,
  "lines": false,
  "percentage": false,
  "points": false,
  "stack": false,
  "steppedLine": false,
  "timeShift": null
}