geobar78
commented
1 year ago Salut désolé pour la lenteur des réponses je ne sais pas pourquoi je n'ai pas de notifs...bref C'est effectivement bizarre j'ai bien 3% et des brouettes et ça colle avec la réalité mon json c'est ça, pour le comparer au tien
{ "id": 20, "gridPos": { "h": 3, "w": 4, "x": 14, "y": 6 }, "type": "blackmirror1-singlestat-math-panel", "title": "Base vs HC/HP", "datasource": { "type": "influxdb", "uid": "Yhbm9AF4k" }, "thresholds": [ { "$$hashKey": "object:48", "color": "#73BF69", "value": -0.1 }, { "$$hashKey": "object:47", "color": "#F2495C", "value": 0 } ], "pluginVersion": "6.6.1", "maxDataPoints": 100, "links": [], "colorValue": true, "decimals": 2, "defaultColor": "rgb(117, 117, 117)", "format": "percent", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:66", "name": "value to text", "value": 1 }, { "$$hashKey": "object:67", "name": "range to text", "value": 2 } ], "math": "100 - (100 * STD / (HP+HC))", "nullPointMode": "connected", "postfixFontSize": "110%", "prefixFontSize": "110%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "targets": [ { "alias": "HC", "datasource": { "type": "influxdb", "uid": "Yhbm9AF4k" }, "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "consumption_detail", "orderByTime": "ASC", "policy": "RETENTION", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "price" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [ { "key": "usage_point_id", "operator": "=~", "value": "/^$pdl$/" }, { "condition": "AND", "key": "measure_type", "operator": "=", "value": "HC" } ] }, { "alias": "HP", "datasource": { "type": "influxdb", "uid": "Yhbm9AF4k" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "consumption_detail", "orderByTime": "ASC", "policy": "RETENTION", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "price" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [ { "key": "usage_point_id", "operator": "=~", "value": "/^$pdl$/" }, { "condition": "AND", "key": "measure_type", "operator": "=", "value": "HP" } ] }, { "alias": "STD", "datasource": { "type": "influxdb", "uid": "Yhbm9AF4k" }, "groupBy": [ { "params": [ "$interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "consumption", "orderByTime": "ASC", "policy": "RETENTION", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "price" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [ { "key": "usage_point_id", "operator": "=~", "value": "/^$pdl$/" } ] } ], "tooltip": { "show": true }, "valueFontSize": "110%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:69", "op": "=", "text": "No data", "value": "null" } ], "valueName": "total", "circleBackground": false, "colorBackground": false, "hideTimeOverride": false, "postfix": "", "prefix": "", "tableColumn": "", "interval": null, "cacheTimeout": null, "nullText": null }
aladin2000
Je me demande pourquoi je constate une différence dans les cumuls de coût entre HP+HC et BASE ce qui fausse gravement le Ration bénéfice HP/HC vs BASE dans cet exemple on regarde bien une différence entre -3% pour HPHC vs +30% dans le graphique