{ "__inputs": [ { "name": "DS_JEEDOM", "label": "Jeedom", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "barchart", "name": "Bar chart", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "9.2.0" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "mappings": [], "max": 25, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 15 }, { "color": "red", "value": 20 } ] }, "unit": "amp" }, "overrides": [ { "matcher": { "id": "byName", "options": "IINST1" }, "properties": [ { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 1" } ] }, { "matcher": { "id": "byName", "options": "IINST2" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 2" } ] }, { "matcher": { "id": "byName", "options": "IINST3" }, "properties": [ { "id": "color", "value": { "fixedColor": "blue", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 3" } ] } ] }, "gridPos": { "h": 9, "w": 11, "x": 0, "y": 0 }, "id": 34, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "query": "from(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Mesure\")\r\n |> filter(fn: (r) => r[\"_field\"] =~ /IINST/)", "refId": "A" } ], "title": "Max Consommation (5 Min.) Periode", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "mappings": [ { "options": { "IINST1": { "index": 0, "text": "Phase 1" }, "IINST2": { "index": 1, "text": "Phase 2" }, "IINST3": { "index": 2, "text": "Phase 3" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 15 }, { "color": "red", "value": 20 } ] } }, "overrides": [] }, "gridPos": { "h": 9, "w": 2, "x": 11, "y": 0 }, "id": 35, "options": { "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": true }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "9.2.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "import \"timezone\"\r\noption location = timezone.location(name: \"Europe/Paris\")\r\n\r\nfrom(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Mesure\")\r\n |> filter(fn: (r) => r[\"_field\"] =~/IINST/)\r\n\r\n |> highestMax(n:3, groupColumns:[\"_field\"])\r\n |> keep(columns: [\"_field\", \"_value\"])\r\n |> sort(columns: [\"_field\"], desc: false)", "refId": "B" } ], "title": "Max Période", "transformations": [], "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "mappings": [ { "options": { "IINST1": { "index": 0, "text": "Phase 1" }, "IINST2": { "index": 1, "text": "Phase 2" }, "IINST3": { "index": 2, "text": "Phase 3" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 15 }, { "color": "red", "value": 20 } ] } }, "overrides": [] }, "gridPos": { "h": 9, "w": 2, "x": 13, "y": 0 }, "hideTimeOverride": true, "id": 26, "options": { "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": true }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "9.2.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "from(bucket: \"Jeedom\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] =~ /IINST/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"Compteur\")\r\n |> keep(columns: [\"_measurement\",\"_value\"])\r\n |> highestMax(n:3, groupColumns:[\"_measurement\"])\r\n |> sort(columns: [\"_measurement\"], desc: false)", "refId": "B" } ], "timeFrom": "5m", "title": "Max 5min", "transformations": [], "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "points", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "mappings": [], "max": 25, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 15 }, { "color": "red", "value": 20 } ] }, "unit": "amp" }, "overrides": [ { "matcher": { "id": "byName", "options": "IINST1 Compteur" }, "properties": [ { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 1" } ] }, { "matcher": { "id": "byName", "options": "IINST2 Compteur" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 2" } ] }, { "matcher": { "id": "byName", "options": "IINST3 Compteur" }, "properties": [ { "id": "color", "value": { "fixedColor": "blue", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 3" } ] } ] }, "gridPos": { "h": 9, "w": 9, "x": 15, "y": 0 }, "hideTimeOverride": false, "id": 20, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "query": "from(bucket: \"Jeedom\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"IINST1\" or r[\"_measurement\"] == \"IINST2\"or r[\"_measurement\"] == \"IINST3\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"Compteur\")", "refId": "A" } ], "timeFrom": "5m", "title": "Amp Temps réel", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 1, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "PAPP_Max" }, "properties": [ { "id": "displayName", "value": "Max W" }, { "id": "color", "value": { "fixedColor": "red", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "PAPP_Min" }, "properties": [ { "id": "displayName", "value": "Min W" }, { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 6, "w": 11, "x": 0, "y": 9 }, "id": 33, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "from(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Mesure\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"PAPP_Min\" or r[\"_field\"] == \"PAPP_Max\")", "refId": "Max" } ], "title": "Max Consommation (5 Min.) Période", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 13800, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Min" }, "properties": [ { "id": "displayName", "value": "Min W" }, { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Max" }, "properties": [ { "id": "displayName", "value": "Max W" }, { "id": "color", "value": { "fixedColor": "red", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 6, "w": 2, "x": 11, "y": 9 }, "id": 36, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "data = from(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Mesure\")\r\n |> filter(fn: (r) => r[\"_field\"] =~ /PAPP/)\r\n\r\nmax = data\r\n |> highestMax(n:1, groupColumns:[\"_field\"])\r\n |> rename(columns: {_value: \"Max\"})\r\n // |> yield(name: \"Max\")\r\n\r\nmin = data\r\n |> lowestMin(n:1, groupColumns:[\"_field\"])\r\n |> rename(columns: {_value: \"Min\"})\r\n // |> yield(name: \"Min\")\r\n\r\njoin(tables: {min: min, max: max}, on: [\"_measurement\"])\r\n|> keep(columns: [\"Min\",\"Max\"])\r\n", "refId": "Min" } ], "title": "Watt Période", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 13800, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Min" }, "properties": [ { "id": "displayName", "value": "Min W" }, { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Max" }, "properties": [ { "id": "displayName", "value": "Max W" }, { "id": "color", "value": { "fixedColor": "red", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 6, "w": 2, "x": 13, "y": 9 }, "hideTimeOverride": true, "id": 28, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "data = from(bucket: \"Jeedom\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"PAPP\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"Compteur\")\r\n\r\nmax = data\r\n |> highestMax(n:1, groupColumns:[\"_field\"])\r\n |> rename(columns: {_value: \"Max\"})\r\n// |> yield(name: \"Max\")\r\n\r\nmin = data\r\n |> lowestMin(n:1, groupColumns:[\"_field\"])\r\n |> rename(columns: {_value: \"Min\"})\r\n// |> yield(name: \"Min\")\r\n\r\njoin(tables: {min: min, max: max}, on: [\"_field\"])\r\n|> keep(columns: [\"Min\",\"Max\"])\r\n", "refId": "Min" } ], "timeFrom": "5m", "title": "Max 5 min", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "points", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 6, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Compteur" }, "properties": [ { "id": "displayName", "value": "Watts" } ] } ] }, "gridPos": { "h": 6, "w": 9, "x": 15, "y": 9 }, "hideTimeOverride": false, "id": 5, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "query": "from(bucket: \"Jeedom\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"PAPP\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"Compteur\")", "refId": "All" } ], "timeFrom": "5m", "title": "Watts Temps réel", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "bars", "fillOpacity": 14, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "mappings": [], "min": 19, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 20 } ] }, "unit": "short" }, "overrides": [ { "matcher": { "id": "byName", "options": "IINST1" }, "properties": [ { "id": "displayName", "value": "Phase 1" }, { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "IINST2" }, "properties": [ { "id": "displayName", "value": "Phase 2" }, { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "IINST3" }, "properties": [ { "id": "color", "value": { "fixedColor": "blue", "mode": "fixed" } }, { "id": "displayName", "value": "Phase 3" } ] }, { "matcher": { "id": "byName", "options": "ADIR1" }, "properties": [ { "id": "displayName", "value": "Délestage Phase 1" }, { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } }, { "id": "custom.drawStyle", "value": "points" }, { "id": "custom.pointSize", "value": 7 } ] }, { "matcher": { "id": "byName", "options": "ADIR2" }, "properties": [ { "id": "displayName", "value": "Délestage Phase 2" }, { "id": "custom.drawStyle", "value": "points" }, { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } }, { "id": "custom.pointSize", "value": 7 } ] }, { "matcher": { "id": "byName", "options": "ADIR3" }, "properties": [ { "id": "displayName", "value": "Délestage Phase 3" }, { "id": "custom.drawStyle", "value": "points" }, { "id": "color", "value": { "fixedColor": "blue", "mode": "fixed" } }, { "id": "custom.pointSize", "value": 7 } ] } ] }, "gridPos": { "h": 8, "w": 11, "x": 0, "y": 15 }, "id": 19, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.5.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "hide": false, "query": "from(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Mesure\")\r\n |> filter(fn: (r) => r[\"_field\"] =~ /ADIR|IINST/)\r\n |> filter(fn: (r) => r[\"_value\"] > 20)\r\n", "refId": "A" } ], "title": "Max >= 20A (5 Min.) ", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatt" }, "overrides": [ { "matcher": { "id": "byName", "options": "STAT_TODAY_HP" }, "properties": [ { "id": "displayName", "value": "Heure Pleine" }, { "id": "color", "value": { "fixedColor": "dark-yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "STAT_TODAY" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } }, { "id": "displayName", "value": "Total Conso" } ] }, { "matcher": { "id": "byName", "options": "STAT_TODAY_HC" }, "properties": [ { "id": "color", "value": { "fixedColor": "super-light-yellow", "mode": "fixed" } }, { "id": "displayName", "value": "Heure Creuse" } ] } ] }, "gridPos": { "h": 8, "w": 13, "x": 11, "y": 15 }, "id": 31, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "query": "import \"timezone\"\r\noption location = timezone.location(name: \"Europe/Paris\")\r\n\r\nfrom(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Conso\")\r\n |> filter(fn: (r) => r[\"_field\"] =~ /STAT_TODAY/\r\n )\r\n\r\n|> pivot(rowKey: [\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")\r\n|> sort(columns: [\"_time\"])", "refId": "Conso" } ], "timeFrom": "2M", "title": "Consommation par jour", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "fillOpacity": 80, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineWidth": 1, "scaleDistribution": { "type": "linear" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatt" }, "overrides": [ { "matcher": { "id": "byName", "options": "BRHCJB_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "light-blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BRHPJB_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "dark-blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "HCHC_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "super-light-yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "HCHP_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BRHCJW_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "#ffffff", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BRHPJW_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "#ffffff", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BRHPJR_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "dark-red", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BRHCJR_Conso" }, "properties": [ { "id": "color", "value": { "fixedColor": "light-red", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 13, "x": 11, "y": 23 }, "id": 32, "options": { "barRadius": 0, "barWidth": 0.97, "groupWidth": 0.7, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "orientation": "auto", "showValue": "auto", "stacking": "none", "tooltip": { "mode": "single", "sort": "none" }, "xField": "_time", "xTickLabelMaxLength": 10, "xTickLabelRotation": -45, "xTickLabelSpacing": 0 }, "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_JEEDOM}" }, "query": "import \"timezone\"\r\noption location = timezone.location(name: \"Europe/Paris\")\r\n\r\nfrom(bucket: \"Jeedom_History\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"Conso\")\r\n |> filter(fn: (r) => r[\"_field\"] =~ /Conso/ )\r\n\r\n|> filter(fn: (r) => r[\"_value\"] != 0 ) \r\n|> pivot(rowKey: [\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")\r\n|> sort(columns: [\"_time\"])", "refId": "Conso" } ], "timeFrom": "2M", "title": "Consommation par jour - Plage", "transformations": [ { "id": "labelsToFields", "options": { "mode": "columns" } } ], "type": "barchart" } ], "refresh": "5s", "schemaVersion": 37, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-24h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Electricité - Conso Journée", "uid": "izswYHlnk", "version": 4, "weekStart": "monday" }