{{msg.payload| number:0}} %",
"layout": "row-spread",
"className": "",
"style": false,
"font": "",
"fontSize": 16,
"color": "#000000",
"x": 760,
"y": 220,
"wires": []
},
{
"id": "c63597be5feefad7",
"type": "ui_group",
"name": "Ökostrom-Anteil",
"tab": "6b520bda.e997a4",
"order": 2,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "66afbcec5bd7c7bb",
"type": "ui_group",
"name": "Einstellungen",
"tab": "2acb95821445c8af",
"order": 3,
"disp": false,
"width": "5",
"collapse": false,
"className": ""
},
{
"id": "6b520bda.e997a4",
"type": "ui_tab",
"name": "System",
"icon": "dashboard",
"order": 7,
"disabled": false,
"hidden": false
},
{
"id": "2acb95821445c8af",
"type": "ui_tab",
"name": "Home",
"icon": "dashboard",
"order": 1,
"disabled": false,
"hidden": false
}
]
```
---
### Author:  [@limago1](https://discourse.nodered.org/u/limago1)
#### Post date: [14 January 2024 21:21 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/2 "2024-01-14T21:21:54Z")
Thanks for sharing this flow! In my idea I want to illuminate a living room bulb according to the signal color.
I imported your nodes and stripped away the dashboard nodes. I riddled now for hours but I can't figure out why I'm getting only
> "RequestError: connect EHOSTUNREACH 192.107.235.120:443"
errors from the request. I had my network config in mind but is OK, API request via browser works also fine.
My small question torwards you is: do encounter any difficulties acessing the API via node red nowadays?
Thank you!
---
### Author:  [@WP-Rue](https://discourse.nodered.org/u/WP-Rue)
#### Post date: [15 January 2024 16:24 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/3 "2024-01-15T16:24:37Z")
> [@limago1](#):
>
> EHOSTUNREACH
Sorry I had no errors so far. Maybe you have config a too high request rate? Or do you have a firewall..?
Good luck.
---
### Author:  [@limago1](https://discourse.nodered.org/u/limago1)
#### Post date: [15 January 2024 19:17 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/4 "2024-01-15T19:17:07Z")
Thank you for the reply - it narrows the possibilities for error.
Also my next guess is network traffic blocking inside my network. I'll check (again).
---
### Author:  [@juntiedt](https://discourse.nodered.org/u/juntiedt)
#### Post date: [16 January 2024 12:12 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/5 "2024-01-16T12:12:39Z")
Hi, I like your input very much. Interesting Information.
I did some exercise with [https://energy-chsrts.info](https://energy-chsrts.info).
Now it is up to dashboard specialists to make good looking graphics.
```auto
[{"id":"f1bddf75aa5337d8","type":"http request","z":"e973a865c2b93001","name":"Energie-Charts","method":"GET","ret":"obj","paytoqs":"body","url":"","tls":"","persist":false,"proxy":"","insecureHTTPParser":false,"authType":"","senderr":false,"headers":[],"x":540,"y":500,"wires":[["54aefef0a699ef9e"]]},{"id":"3f1afcf8b53a9c34","type":"inject","z":"e973a865c2b93001","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":500,"wires":[["8236414b3d6d850a","862d1403bfd9fa35"]]},{"id":"54aefef0a699ef9e","type":"function","z":"e973a865c2b93001","name":"function 164","func":"let aktualisierung = moment( ).tz(\"Europe/Berlin\").format(\"DD-MM-YYYY HH:mm:ss\");\nlet data_array = [];\nlet len = msg.payload.unix_seconds.length;\n\nfor (let i = 0; i < len; i++) {\n let t_string = moment(msg.payload.unix_seconds[i] * 1000).tz(\"Europe/Berlin\").format(\"DD-MM-YYYY HH:mm:ss\");\n let sha = msg.payload.share[i];\n let sig = msg.payload.signal[i];\n\n data_array[0] = msg.payload.unix_seconds[i];\n data_array[1] = t_string;\n data_array[2] = sha;\n data_array[3] = parseFloat((100 - sha).toFixed(1));\n data_array[4] = sig;\n data_array[5] = sig_txt(sig);\n data_array[6] = sig_color(sig); \n data_array[7] = msg.payload.substitute;\n data_array[8] = aktualisierung; \n \n node.send([{ payload: msg.payload.unix_seconds[i] },\n { payload: t_string },\n { payload:sha },\n { payload: parseFloat((100 - sha).toFixed(1)) }, \n { payload:sig },\n { payload: sig_txt(sig) },\n { payload: sig_color(sig) }, \n { payload:msg.payload.substitute },\n { payload: aktualisierung },\n { payload:data_array } \n ]);\n};\nreturn null;\n\n\nfunction sig_txt(n){\n if (n === -1){\n return \"grid congestion\";\n }\n else if (n === 0){\n return \"low renewable share\";\n }\n else if (n === 1) {\n return \"average renewable share\";\n }\n else if (n === 2) {\n return \"high renewable share\";\n } \n else return \"Signal unknown\"; \n}\n\nfunction sig_color(n) {\n if (n === -1) {\n return \"red\";\n }\n else if (n === 0) {\n return \"orange\";\n }\n else if (n === 1) {\n return \"yellow\";\n }\n else if (n === 2) {\n return \"green\";\n }\n else return \"Color unknown\";\n}","outputs":10,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[{"var":"moment","module":"moment"},{"var":"momentTimezone","module":"moment-timezone"}],"x":730,"y":500,"wires":[["c099d35b046148e9"],["95215d5284d6e494"],["bcb5d8481bee98d6","4e37a222b7b0ce9f"],["5b996e28c17f0ed9"],["4228528078780804"],["cfe9b58bdd851037"],["6eccfdce5b083a3d"],["31953f1bc24080a3"],["6b64aee93efde966"],["3cccf2fc633ffaf8"]]},{"id":"95215d5284d6e494","type":"debug","z":"e973a865c2b93001","name":"debug x2","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":360,"wires":[]},{"id":"5b996e28c17f0ed9","type":"debug","z":"e973a865c2b93001","name":"debug x4","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":440,"wires":[]},{"id":"4228528078780804","type":"debug","z":"e973a865c2b93001","name":"debug x5","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":480,"wires":[]},{"id":"cfe9b58bdd851037","type":"debug","z":"e973a865c2b93001","name":"debug x6","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":520,"wires":[]},{"id":"c099d35b046148e9","type":"debug","z":"e973a865c2b93001","name":"debug x1","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":320,"wires":[]},{"id":"6eccfdce5b083a3d","type":"debug","z":"e973a865c2b93001","name":"debug x7","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":560,"wires":[]},{"id":"31953f1bc24080a3","type":"debug","z":"e973a865c2b93001","name":"debug x8","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":600,"wires":[]},{"id":"8236414b3d6d850a","type":"change","z":"e973a865c2b93001","name":"","rules":[{"t":"set","p":"url","pt":"msg","to":"https://api.energy-charts.info/signal?country=de&postal_code=89343","tot":"str"},{"t":"set","p":"count","pt":"flow","to":"0","tot":"num"}],"action":"","property":"","from":"","to":"","reg":false,"x":360,"y":500,"wires":[["f1bddf75aa5337d8"]]},{"id":"bcb5d8481bee98d6","type":"debug","z":"e973a865c2b93001","name":"debug x3","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":400,"wires":[]},{"id":"6b64aee93efde966","type":"debug","z":"e973a865c2b93001","name":"debug x9","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":640,"wires":[]},{"id":"3cccf2fc633ffaf8","type":"debug","z":"e973a865c2b93001","name":"debug x10","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":990,"y":680,"wires":[]},{"id":"28b88c058eb61ef8","type":"ui_chart","z":"e973a865c2b93001","name":"Green Energy","group":"1d3119656d7b59a6","order":29,"width":0,"height":0,"label":"Green energy (one bar every 15 min)","chartType":"bar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"110","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":true,"useUTC":false,"colors":["#aef9af","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":1360,"y":400,"wires":[[]]},{"id":"4e37a222b7b0ce9f","type":"function","z":"e973a865c2b93001","name":"function 165","func":"let z = flow.get('count') + 1;\nflow.set('count', z );\nreturn { label:z, payload: msg.payload };\n\n","outputs":1,"timeout":0,"noerr":0,"initialize":"// Der Code hier wird ausgeführt,\n// wenn der Node gestartet wird","finalize":"","libs":[],"x":1170,"y":400,"wires":[["28b88c058eb61ef8"]]},{"id":"862d1403bfd9fa35","type":"function","z":"e973a865c2b93001","name":"reset/init","func":"return({ payload: [] });","outputs":1,"timeout":0,"noerr":0,"initialize":"// Der Code hier wird ausgeführt,\n// wenn der Node gestartet wird\nnode.send({payload:[]});","finalize":"","libs":[],"x":340,"y":540,"wires":[["a63db9465a12fe1a"]]},{"id":"a63db9465a12fe1a","type":"link out","z":"e973a865c2b93001","name":"reset-out","mode":"link","links":["83dcb6769e812448"],"x":435,"y":540,"wires":[]},{"id":"83dcb6769e812448","type":"link in","z":"e973a865c2b93001","name":"reset-in","links":["a63db9465a12fe1a"],"x":1225,"y":440,"wires":[["28b88c058eb61ef8"]]},{"id":"1d3119656d7b59a6","type":"ui_group","name":"green energy","tab":"8957e5cd1f4df0d4","order":1,"disp":true,"width":"25","collapse":false,"className":""},{"id":"8957e5cd1f4df0d4","type":"ui_tab","name":"Bar Test","icon":"dashboard","order":16,"disabled":false,"hidden":false}]
```
---
### Author:  [@WP-Rue](https://discourse.nodered.org/u/WP-Rue)
#### Post date: [29 January 2024 19:13 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/6 "2024-01-29T19:13:29Z")
I import your flow and had a complete timeout, if I deploy...!!!
---
### Author:  [@juntiedt](https://discourse.nodered.org/u/juntiedt)
#### Post date: [30 January 2024 16:11 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/7 "2024-01-30T16:11:50Z")
Hi WP-Rue,
load these nodes into a fresh, empty flow. Then check your dashboard. There have to be a chart and a button.
This should look like this.
```auto
[{"id":"3f1afcf8b53a9c34","type":"inject","z":"e973a865c2b93001","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":540,"wires":[["8236414b3d6d850a","862d1403bfd9fa35"]]},{"id":"54aefef0a699ef9e","type":"function","z":"e973a865c2b93001","name":"function 164","func":"const aktualisierung = moment( ).tz(\"Europe/Berlin\").format(\"DD-MM-YYYY HH:mm:ss\");\nconst len = msg.payload.unix_seconds.length;\nconst data_array = [];\n\nfor (let i = 0; i < len; i++) {\n const t_string = moment(msg.payload.unix_seconds[i] * 1000).tz(\"Europe/Berlin\").format(\"DD-MM-YYYY HH:mm:ss\");\n const sha = msg.payload.share[i];\n const sig = msg.payload.signal[i];\n\n data_array[0] = msg.payload.unix_seconds[i];\n data_array[1] = t_string;\n data_array[2] = sha;\n data_array[3] = parseFloat((100 - sha).toFixed(1));\n data_array[4] = sig;\n data_array[5] = sig_txt(sig);\n data_array[6] = sig_color(sig); \n data_array[7] = msg.payload.substitute;\n data_array[8] = aktualisierung; \n \n node.send([{ payload: msg.payload.unix_seconds[i] },\n { payload: t_string },\n { payload:sha },\n { payload: parseFloat((100 - sha).toFixed(1)) }, \n { payload:sig },\n { payload: sig_txt(sig) },\n { payload: sig_color(sig) }, \n { payload:msg.payload.substitute },\n { payload: aktualisierung },\n { payload:data_array } \n ]);\n};\nreturn null;\n\n//--------------------------------------------------------------------------\n\nfunction sig_txt(n){\n if (n === -1){\n return \"grid congestion\";\n }\n else if (n === 0){\n return \"low renewable share\";\n }\n else if (n === 1) {\n return \"average renewable share\";\n }\n else if (n === 2) {\n return \"high renewable share\";\n } \n else return \"Signal unknown\"; \n}\n\n//--------------------------------------------------------------------------\n\nfunction sig_color(n) {\n if (n === -1) {\n return \"red\";\n }\n else if (n === 0) {\n return \"orange\";\n }\n else if (n === 1) {\n return \"yellow\";\n }\n else if (n === 2) {\n return \"green\";\n }\n else return \"Color unknown\";\n}\n\n//--------------------------------------------------------------------------","outputs":10,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[{"var":"moment","module":"moment"},{"var":"momentTimezone","module":"moment-timezone"}],"x":730,"y":500,"wires":[["c099d35b046148e9"],["95215d5284d6e494"],["bcb5d8481bee98d6","4208940eacbd2762"],["5b996e28c17f0ed9"],["4228528078780804"],["cfe9b58bdd851037"],["6eccfdce5b083a3d"],["31953f1bc24080a3"],["6b64aee93efde966"],["3cccf2fc633ffaf8"]]},{"id":"95215d5284d6e494","type":"debug","z":"e973a865c2b93001","name":"debug x2","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":360,"wires":[]},{"id":"5b996e28c17f0ed9","type":"debug","z":"e973a865c2b93001","name":"debug x4","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":440,"wires":[]},{"id":"4228528078780804","type":"debug","z":"e973a865c2b93001","name":"debug x5","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":480,"wires":[]},{"id":"cfe9b58bdd851037","type":"debug","z":"e973a865c2b93001","name":"debug x6","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":520,"wires":[]},{"id":"c099d35b046148e9","type":"debug","z":"e973a865c2b93001","name":"debug x1","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":320,"wires":[]},{"id":"6eccfdce5b083a3d","type":"debug","z":"e973a865c2b93001","name":"debug x7","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":560,"wires":[]},{"id":"31953f1bc24080a3","type":"debug","z":"e973a865c2b93001","name":"debug x8","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":600,"wires":[]},{"id":"1e979cd535f7aad4","type":"link call","z":"e973a865c2b93001","name":"http-request-in 1","links":["d59a2325dd14c795"],"linkType":"static","timeout":"90","x":540,"y":500,"wires":[["54aefef0a699ef9e"]]},{"id":"8236414b3d6d850a","type":"change","z":"e973a865c2b93001","name":"","rules":[{"t":"set","p":"url","pt":"msg","to":"https://api.energy-charts.info/signal?country=de&postal_code=89343","tot":"str"},{"t":"set","p":"count","pt":"flow","to":"0","tot":"num"}],"action":"","property":"","from":"","to":"","reg":false,"x":340,"y":500,"wires":[["1e979cd535f7aad4"]]},{"id":"bcb5d8481bee98d6","type":"debug","z":"e973a865c2b93001","name":"debug x3","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":400,"wires":[]},{"id":"6b64aee93efde966","type":"debug","z":"e973a865c2b93001","name":"debug x9","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":980,"y":640,"wires":[]},{"id":"3cccf2fc633ffaf8","type":"debug","z":"e973a865c2b93001","name":"debug x10","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":990,"y":680,"wires":[]},{"id":"28b88c058eb61ef8","type":"ui_chart","z":"e973a865c2b93001","name":"Green Energy","group":"1d3119656d7b59a6","order":1,"width":0,"height":0,"label":"Green energy (one bar every 15 min starting from load)","chartType":"bar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"150","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":true,"useUTC":false,"colors":["#aef9af","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":1360,"y":400,"wires":[[]]},{"id":"4e37a222b7b0ce9f","type":"function","z":"e973a865c2b93001","name":"function 165","func":"let z = flow.get('count') + 1;\nflow.set('count', z );\nreturn { label:z, payload: msg.payload };\n\n","outputs":1,"timeout":0,"noerr":0,"initialize":"// Der Code hier wird ausgeführt,\n// wenn der Node gestartet wird","finalize":"","libs":[],"x":1170,"y":400,"wires":[["28b88c058eb61ef8"]]},{"id":"862d1403bfd9fa35","type":"function","z":"e973a865c2b93001","name":"reset/init","func":"return({ payload: [] });","outputs":1,"timeout":0,"noerr":0,"initialize":"// Der Code hier wird ausgeführt,\n// wenn der Node gestartet wird\nnode.send({payload:[]});","finalize":"","libs":[],"x":320,"y":540,"wires":[["a63db9465a12fe1a"]]},{"id":"a63db9465a12fe1a","type":"link out","z":"e973a865c2b93001","name":"reset-out","mode":"link","links":["83dcb6769e812448"],"x":415,"y":540,"wires":[]},{"id":"83dcb6769e812448","type":"link in","z":"e973a865c2b93001","name":"reset-in","links":["a63db9465a12fe1a"],"x":1225,"y":440,"wires":[["28b88c058eb61ef8"]]},{"id":"f33e7b54ef289ecd","type":"ui_button","z":"e973a865c2b93001","name":"","group":"1d3119656d7b59a6","order":2,"width":0,"height":0,"passthru":false,"label":"start loading","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"","payloadType":"str","topic":"topic","topicType":"msg","x":150,"y":500,"wires":[["8236414b3d6d850a","862d1403bfd9fa35"]]},{"id":"4208940eacbd2762","type":"junction","z":"e973a865c2b93001","x":920,"y":400,"wires":[["4e37a222b7b0ce9f"]]},{"id":"1d3119656d7b59a6","type":"ui_group","name":"green energy","tab":"8957e5cd1f4df0d4","order":1,"disp":true,"width":"25","collapse":false,"className":""},{"id":"8957e5cd1f4df0d4","type":"ui_tab","name":"Bar Test","icon":"dashboard","order":16,"disabled":false,"hidden":false}]
```
---
### Author:  [@juntiedt](https://discourse.nodered.org/u/juntiedt)
#### Post date: [30 January 2024 19:18 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/8 "2024-01-30T19:18:14Z")
Hi, I just found that I have a link node (http-request-in 1) in my flow wich you should replace with an http request node in order to get the right data.
---
### Author:  [@WP-Rue](https://discourse.nodered.org/u/WP-Rue)
#### Post date: [13 December 2024 21:48 UTC](https://discourse.nodered.org/t/share-of-regenerative-electricity-energie-chart-frauenhofer/83913/9 "2024-12-13T21:48:49Z")
[https://flows.nodered.org/node/node-red-contrib-energy-charts](https://flows.nodered.org/node/node-red-contrib-energy-charts)
There could be an update in the future..(Just see, not my work)