Display hourly production in bar graph

General
1

Hello! I Need to display hourly production (24 hr) on a bar chart, below given is the flow I've created :

  • sharing only half of the flow due to character limitation of 32000.
[{"id":"887bdbcf.967d28","type":"function","z":"dc05cb71.fd2b78","name":"1st hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='firsthr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":733,"wires":[["738030fe.57821","45a6ea17.598df4","c3070d88.15fb3"]]},{"id":"738030fe.57821","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1347,"y":728,"wires":[]},{"id":"33015992.c29d26","type":"function","z":"dc05cb71.fd2b78","name":"2nd hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='secondhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":800,"wires":[["45a6ea17.598df4","182bd831.129488"]]},{"id":"45a6ea17.598df4","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":801,"wires":[["76e8eb36.54d2d4","176775f3.047daa"]]},{"id":"76e8eb36.54d2d4","type":"function","z":"dc05cb71.fd2b78","name":"2nd hr - 1st hr","func":"msg.payload = (msg.payload.secondhr - msg.payload.firsthr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":781,"wires":[["72a8a588.bca9bc","2d6b6334.a2101c"]]},{"id":"176775f3.047daa","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":821,"wires":[]},{"id":"f5ff1fef.f3026","type":"function","z":"dc05cb71.fd2b78","name":"3rd hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='thirdhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":872,"wires":[["182bd831.129488","bba8e527.573368"]]},{"id":"182bd831.129488","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":873,"wires":[["13334bbc.8e7194","3fbd997.1515166"]]},{"id":"13334bbc.8e7194","type":"function","z":"dc05cb71.fd2b78","name":"3rd hr - 2nd hr","func":"msg.payload = (msg.payload.thirdhr - msg.payload.secondhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":873,"wires":[["76c66b57.1c1434","9e505d5b.a56dc"]]},{"id":"3fbd997.1515166","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":913,"wires":[]},{"id":"b338ed3f.f464b","type":"function","z":"dc05cb71.fd2b78","name":"4th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='fourthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":965,"wires":[["bba8e527.573368","10e9c8ec.3fa287"]]},{"id":"bba8e527.573368","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":966,"wires":[["f1b9c397.a0f41","584ea7cc.1e3b68"]]},{"id":"f1b9c397.a0f41","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1006,"wires":[]},{"id":"5c1b808c.345ca","type":"function","z":"dc05cb71.fd2b78","name":"5th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='fifthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1056,"wires":[["10e9c8ec.3fa287","c39e8fec.7f71"]]},{"id":"10e9c8ec.3fa287","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1057,"wires":[["4165f1ef.54d43","eca4c2cb.bb234"]]},{"id":"791226a1.ca7ab8","type":"function","z":"dc05cb71.fd2b78","name":"6th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='sixthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1143,"wires":[["c39e8fec.7f71","42b7460.243fabc"]]},{"id":"c39e8fec.7f71","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1144,"wires":[["9ec4fe6f.09617","e293e188.4a832"]]},{"id":"1ce80728.9b0e49","type":"function","z":"dc05cb71.fd2b78","name":"7th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='seventhhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1233,"wires":[["42b7460.243fabc","a3fdc32d.f0014"]]},{"id":"42b7460.243fabc","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1234,"wires":[["f3646ffa.b332c","8d0b7577.05ca88"]]},{"id":"e3090067.e5174","type":"function","z":"dc05cb71.fd2b78","name":"8th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='eighthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1322,"wires":[["a3fdc32d.f0014","f260153.16ce3e8"]]},{"id":"a3fdc32d.f0014","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1323,"wires":[["94e6632.6a729a","545f9c39.528d94"]]},{"id":"59531859.ce3c98","type":"function","z":"dc05cb71.fd2b78","name":"9th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='ninthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1410,"wires":[["f260153.16ce3e8","ad4d9ab7.e91208"]]},{"id":"f260153.16ce3e8","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1411,"wires":[["ef8b642b.529678","d9fecc75.f0494"]]},{"id":"6f8bbee.6bec64","type":"function","z":"dc05cb71.fd2b78","name":"10th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='tenthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":780,"y":1499,"wires":[["ad4d9ab7.e91208","135b9052.fceac"]]},{"id":"ad4d9ab7.e91208","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1500,"wires":[["5139fd70.a7de54","df08c9b8.a097d8"]]},{"id":"fbf9eb4d.985b88","type":"function","z":"dc05cb71.fd2b78","name":"11th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='eleventhhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":770,"y":1589,"wires":[["135b9052.fceac","484a9f2f.f019"]]},{"id":"135b9052.fceac","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1590,"wires":[["33f8271b.61c9f8","3fde8077.ac2f9"]]},{"id":"9f22729c.087ac","type":"function","z":"dc05cb71.fd2b78","name":"12th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='twelfthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":780,"y":1678,"wires":[["484a9f2f.f019","1e0becf8.c37a63"]]},{"id":"484a9f2f.f019","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1679,"wires":[["2cf8449d.4666bc","b97d23ab.a8824"]]},{"id":"ade1634b.10b6","type":"function","z":"dc05cb71.fd2b78","name":"13th hr","func":"msg.payload = Number(msg.payload);\nmsg.topic='thirteenthhr';\nA = msg.payload;\nB = Math.pow(A,2);\nmsg.payload = Math.pow(B,0.5);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":780,"y":1767,"wires":[["1e0becf8.c37a63","825ac270.f1af7"]]},{"id":"1e0becf8.c37a63","type":"join","z":"dc05cb71.fd2b78","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":true,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":950,"y":1768,"wires":[["a6eaa974.2ea048","6640fe5d.70e0e"]]},{"id":"4165f1ef.54d43","type":"function","z":"dc05cb71.fd2b78","name":"5th hr - 4th hr","func":"msg.payload = (msg.payload.fifthhr - msg.payload.fourthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1057,"wires":[["affcab5d.fb7418","f51ddfb0.e5bf1"]]},{"id":"584ea7cc.1e3b68","type":"function","z":"dc05cb71.fd2b78","name":"4th hr - 3rd hr","func":"msg.payload = (msg.payload.fourthhr - msg.payload.thirdhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":966,"wires":[["77ef78e7.8b78a8","b320fa00.841aa8"]]},{"id":"9ec4fe6f.09617","type":"function","z":"dc05cb71.fd2b78","name":"6th hr - 5th hr","func":"msg.payload = (msg.payload.sixthhr - msg.payload.fifthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1144,"wires":[["8b8240a7.987c3","474e2a03.9f0af4"]]},{"id":"eca4c2cb.bb234","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1097,"wires":[]},{"id":"e293e188.4a832","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1184,"wires":[]},{"id":"f3646ffa.b332c","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1274,"wires":[]},{"id":"94e6632.6a729a","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1363,"wires":[]},{"id":"ef8b642b.529678","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1451,"wires":[]},{"id":"5139fd70.a7de54","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1540,"wires":[]},{"id":"33f8271b.61c9f8","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1630,"wires":[]},{"id":"2cf8449d.4666bc","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1719,"wires":[]},{"id":"a6eaa974.2ea048","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1130,"y":1808,"wires":[]},{"id":"8d0b7577.05ca88","type":"function","z":"dc05cb71.fd2b78","name":"7th hr - 6th hr","func":"msg.payload = (msg.payload.seventhhr - msg.payload.sixthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1234,"wires":[["926acf6c.96024","673089ab.5f19b8"]]},{"id":"545f9c39.528d94","type":"function","z":"dc05cb71.fd2b78","name":"8th hr - 7th hr","func":"msg.payload = (msg.payload.eighthhr - msg.payload.seventhhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1323,"wires":[["c29c15b7.269138","73ae88a8.2cc7c8"]]},{"id":"d9fecc75.f0494","type":"function","z":"dc05cb71.fd2b78","name":"9th hr - 8th hr","func":"msg.payload = (msg.payload.ninthhr - msg.payload.eighthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1411,"wires":[["73f4f446.9018ac","e45353e1.b65e2"]]},{"id":"df08c9b8.a097d8","type":"function","z":"dc05cb71.fd2b78","name":"10th hr - 9th hr","func":"msg.payload = (msg.payload.tenthhr - msg.payload.ninthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1500,"wires":[["6da9e1ba.1507e","1edef913.27f427"]]},{"id":"3fde8077.ac2f9","type":"function","z":"dc05cb71.fd2b78","name":"11th hr - 10th hr","func":"msg.payload = (msg.payload.eleventhhr - msg.payload.tenthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1590,"wires":[["37ab4a54.b4f5e6","74b0151d.06d53c"]]},{"id":"b97d23ab.a8824","type":"function","z":"dc05cb71.fd2b78","name":"12th hr - 11th hr","func":"msg.payload = (msg.payload.twelfthhr - msg.payload.eleventhhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1679,"wires":[["68881e65.aca8e","b88239a6.213ec8"]]},{"id":"6640fe5d.70e0e","type":"function","z":"dc05cb71.fd2b78","name":"13th hr - 12th hr","func":"msg.payload = (msg.payload.thirteenthhr - msg.payload.twelfthhr);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1140,"y":1768,"wires":[["c627df32.43213","d2624c3c.cdab1"]]},{"id":"db8fc03d.8434e","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631","87c11fb5.11495","759bf909.560238"],"x":655,"y":740,"wires":[["887bdbcf.967d28"]]},{"id":"c5ea194e.63a078","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":800,"wires":[["33015992.c29d26"]]},{"id":"21ad2e80.7042e2","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":872,"wires":[["f5ff1fef.f3026"]]},{"id":"62791b0d.1a4304","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":965,"wires":[["b338ed3f.f464b"]]},{"id":"903bb1a8.4f0e9","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":1056,"wires":[["5c1b808c.345ca"]]},{"id":"7f91751c.27bbec","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":1143,"wires":[["791226a1.ca7ab8"]]},{"id":"142cc3f7.f8b43c","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["1d762f01.992631"],"x":655,"y":1233,"wires":[["1ce80728.9b0e49"]]},{"id":"390840a6.327ee","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1322,"wires":[["e3090067.e5174"]]},{"id":"84561d53.60bb1","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1410,"wires":[["59531859.ce3c98"]]},{"id":"60a895bc.8c84ec","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1499,"wires":[["6f8bbee.6bec64"]]},{"id":"1cfad5f0.eb641a","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1589,"wires":[["fbf9eb4d.985b88"]]},{"id":"732e441f.8546ac","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1678,"wires":[["9f22729c.087ac"]]},{"id":"adbc7d85.23fab","type":"link in","z":"dc05cb71.fd2b78","name":"","links":[],"x":655,"y":1767,"wires":[["ade1634b.10b6"]]},{"id":"72a8a588.bca9bc","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":781,"wires":[]},{"id":"76c66b57.1c1434","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":873,"wires":[]},{"id":"77ef78e7.8b78a8","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":966,"wires":[]},{"id":"affcab5d.fb7418","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1057,"wires":[]},{"id":"8b8240a7.987c3","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1144,"wires":[]},{"id":"926acf6c.96024","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1234,"wires":[]},{"id":"c29c15b7.269138","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1323,"wires":[]},{"id":"73f4f446.9018ac","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1411,"wires":[]},{"id":"6da9e1ba.1507e","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1500,"wires":[]},{"id":"37ab4a54.b4f5e6","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1590,"wires":[]},{"id":"68881e65.aca8e","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1679,"wires":[]},{"id":"c627df32.43213","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":1768,"wires":[]},{"id":"763f517a.259b","type":"link in","z":"dc05cb71.fd2b78","name":"","links":["72a8a588.bca9bc","76c66b57.1c1434","77ef78e7.8b78a8","affcab5d.fb7418","8b8240a7.987c3","926acf6c.96024","c29c15b7.269138","73f4f446.9018ac","6da9e1ba.1507e","37ab4a54.b4f5e6","68881e65.aca8e","c627df32.43213","68ac5d8c.9eeb14","26500912.9169d6","cfc21f02.ad17b","406e6b54.b7a504","a8ca7e4f.23d13","29db3383.d4ca8c","595467b1.318188","4467006a.8c711","f7bedbd5.23a628","c388dce0.df343","bb6f6d1e.f7709","c3070d88.15fb3"],"x":1555,"y":1020,"wires":[["7b68c736.103a08"]]},{"id":"9c3b0f68.ac981","type":"influxdb in","z":"dc05cb71.fd2b78","influxdb":"ed827551.b18638","name":"","query":"SELECT * FROM \"hourlyprod\".\"autogen\".\"hourlyprod M02CN001\" WHERE time > now() -24h","rawOutput":false,"precision":"","retentionPolicy":"","org":"my-org","x":1820,"y":880,"wires":[["fb8710ef.94d52","b7a37ee4.e9747","8a1aef3f.986ad"]]},{"id":"7b68c736.103a08","type":"influxdb out","z":"dc05cb71.fd2b78","influxdb":"366c49bb.664296","name":"M02CN001","measurement":"hourlyprod M02CN001","precision":"","retentionPolicy":"","database":"hourlyprod","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"organisation","bucket":"bucket","x":1710,"y":1020,"wires":[]},{"id":"2d6b6334.a2101c","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":820,"wires":[]},{"id":"9e505d5b.a56dc","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":909,"wires":[]},{"id":"b320fa00.841aa8","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1000,"wires":[]},{"id":"f51ddfb0.e5bf1","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1093,"wires":[]},{"id":"474e2a03.9f0af4","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1180,"wires":[]},{"id":"673089ab.5f19b8","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1269,"wires":[]},{"id":"73ae88a8.2cc7c8","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1357,"wires":[]},{"id":"e45353e1.b65e2","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1445,"wires":[]},{"id":"1edef913.27f427","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1540,"wires":[]},{"id":"74b0151d.06d53c","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1622,"wires":[]},{"id":"b88239a6.213ec8","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1709,"wires":[]},{"id":"d2624c3c.cdab1","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":false,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":1801,"wires":[]},{"id":"c3070d88.15fb3","type":"link out","z":"dc05cb71.fd2b78","name":"","links":["763f517a.259b"],"x":1295,"y":691,"wires":[]},{"id":"d50b8915.e09d68","type":"inject","z":"dc05cb71.fd2b78","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":1640,"y":880,"wires":[["9c3b0f68.ac981"]]},{"id":"b7a37ee4.e9747","type":"ui_chart","z":"dc05cb71.fd2b78","name":"","group":"b0f97496.a4d498","order":9,"width":"24","height":"4","label":"A","chartType":"bar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"1","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"x":2030,"y":860,"wires":[[]]},{"id":"fb8710ef.94d52","type":"debug","z":"dc05cb71.fd2b78","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":2050,"y":900,"wires":[]},{"id":"8a1aef3f.986ad","type":"ui_table","z":"dc05cb71.fd2b78","group":"b0f97496.a4d498","name":"","order":11,"width":"9","height":"4","columns":[],"outputs":0,"cts":false,"x":2030,"y":960,"wires":[]},{"id":"ed827551.b18638","type":"influxdb","hostname":"127.0.0.1","port":"8086","protocol":"http","database":"OEE","name":"1.x","usetls":false,"tls":"d50d0c9f.31e858","influxdbVersion":"1.x","url":"http://localhost:8086","rejectUnauthorized":true},{"id":"366c49bb.664296","type":"influxdb","hostname":"127.0.0.1","port":"8086","protocol":"http","database":"temp","name":"Influx","usetls":false,"tls":"","influxdbVersion":"1.8-flux","url":"http://localhost:8086/","rejectUnauthorized":false},{"id":"b0f97496.a4d498","type":"ui_group","name":"testing","tab":"152250d2.cae22f","order":1,"disp":true,"width":24,"collapse":false},{"id":"d50d0c9f.31e858","type":"tls-config","name":"","cert":"","key":"","ca":"","certname":"","keyname":"","caname":"","servername":"","verifyservercert":false},{"id":"152250d2.cae22f","type":"ui_tab","name":"Testing","icon":"dashboard","order":14,"disabled":false,"hidden":false}]

Can anyone help me on this

2

Hi

Firstly, most of what you posted is completely irrelevant in helping you as the data comes from influx...

image
image1207Ă—956 139 KB

In order to actually help, you need to show us the content of your data and provide a sample by clicking the "Copy Value" button when hovering over the data.

E.g...
BX00Cy7yHi


If you want to solve this yourself, read the built in help

image
image513Ă—502 18.5 KB

3

@Steve-Mcl , sharing the copied value

screenshot3

[{"time":"2021-04-03T09:35:32.000Z","value":3},{"time":"2021-04-03T09:35:37.000Z","value":5},{"time":"2021-04-03T09:35:38.000Z","value":2},{"time":"2021-04-03T09:35:39.000Z","value":2},{"time":"2021-04-03T09:35:57.000Z","value":10},{"time":"2021-04-03T09:35:58.000Z","value":10},{"time":"2021-04-03T09:35:59.000Z","value":7},{"time":"2021-04-03T09:36:00.000Z","value":7},{"time":"2021-04-03T09:36:01.000Z","value":6},{"time":"2021-04-03T09:36:02.000Z","value":7},{"time":"2021-04-03T09:36:03.000Z","value":15},{"time":"2021-04-03T09:36:04.000Z","value":12},{"time":"2021-04-03T09:36:05.000Z","value":9},{"time":"2021-04-03T09:36:06.000Z","value":10},{"time":"2021-04-03T09:36:07.000Z","value":9},{"time":"2021-04-03T09:36:08.000Z","value":8},{"time":"2021-04-03T09:36:09.000Z","value":8},{"time":"2021-04-03T09:36:10.000Z","value":11},{"time":"2021-04-03T09:36:11.000Z","value":11},{"time":"2021-04-03T09:36:12.000Z","value":7},{"time":"2021-04-03T09:36:13.000Z","value":7},{"time":"2021-04-03T09:36:14.000Z","value":15},{"time":"2021-04-03T09:36:15.000Z","value":8},{"time":"2021-04-03T09:36:16.000Z","value":8}]
4

From the docs, you need that data to look like this....

for bars of the same colour, set the flag Use first colour for all bars in the node configuration, and set labels for each column

[{
    "series": [ "X" ],
    "data": [ [5,6,9] ],
    "labels": [ "Jan", "Feb", "Mar" ]
}]

As you can see, your data in an [array] of {objects} with each containing 2 properties time and value.

So do you want me to do this for you (you wont really learn much) or are you going to give it a go yourself (and learn lots)?

5

@Steve-Mcl , your help will be appreciated :slightly_smiling_face:. I've been struggling to get results for some days now :neutral_face:. Being a mechanical engineer I'm an infant :baby_bottle: :baby: who just stepped in coding.

6

OK, well you will miss out on solving the puzzle, but here goes.

We need to convert

///current format...
[{"time":"2021-04-03T09:35:32.000Z","value":3}]

to

[{
    "series": [ "X" ],
    "data": [ [5,6,9] ],
    "labels": [ "Jan", "Feb", "Mar" ]
}]

If we loop each row and take the time and add it to an array called labels and take the value and add that to another array called data we are half way there. The last piece of the puzzle is to put them into the required format.

function node (deliberately verbose and long hand to be as clear as possible)...

/* required format...
[{
    "series": [ "X" ],
    "data": [ [5,6,9] ],
    "labels": [ "Jan", "Feb", "Mar" ]
}]
*/

/* current format...
[{"time":"2021-04-03T09:35:32.000Z","value":3}]
*/

var influxData = msg.payload; //for easy access to data & to clarify what we are working with.
msg.influxData = influxData; //keep a copy for reference (see debug output)

var data = []; //an array for bar chart data values
var labels = []; //an array for bar chart label values
for (let index = 0; index < influxData.length; index++) {
    const element = influxData[index]; //get this row of data
    const datetime = new Date(element.time); //get the time as a datetime object
    
    //get HH:mm and push it into the labels
    const time = datetime.getHours() + ":" + datetime.getMinutes();
    labels.push(time);

    //push value into the data
    const value = element.value;
    data.push(value);
}

//set payload to the correct bar chart format...
msg.payload = [{
    "series": ["X"],
    "data": [data],
    "labels": labels
}]

return msg;

image
image344Ă—896 18.8 KB

NOTE ↑ I dont think your data is really "hourly" data (I'll leave that for your to sort out)

the demo flow...

[{"id":"7a91d5d2.0b8dbc","type":"inject","z":"83a23089.dc697","name":"demo influx data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"time\":\"2021-04-03T09:35:32.000Z\",\"value\":3},{\"time\":\"2021-04-03T09:35:37.000Z\",\"value\":5},{\"time\":\"2021-04-03T09:35:38.000Z\",\"value\":2},{\"time\":\"2021-04-03T09:35:39.000Z\",\"value\":2},{\"time\":\"2021-04-03T09:35:57.000Z\",\"value\":10},{\"time\":\"2021-04-03T09:35:58.000Z\",\"value\":10},{\"time\":\"2021-04-03T09:35:59.000Z\",\"value\":7},{\"time\":\"2021-04-03T09:36:00.000Z\",\"value\":7},{\"time\":\"2021-04-03T09:36:01.000Z\",\"value\":6},{\"time\":\"2021-04-03T09:36:02.000Z\",\"value\":7},{\"time\":\"2021-04-03T09:36:03.000Z\",\"value\":15},{\"time\":\"2021-04-03T09:36:04.000Z\",\"value\":12},{\"time\":\"2021-04-03T09:36:05.000Z\",\"value\":9},{\"time\":\"2021-04-03T09:36:06.000Z\",\"value\":10},{\"time\":\"2021-04-03T09:36:07.000Z\",\"value\":9},{\"time\":\"2021-04-03T09:36:08.000Z\",\"value\":8},{\"time\":\"2021-04-03T09:36:09.000Z\",\"value\":8},{\"time\":\"2021-04-03T09:36:10.000Z\",\"value\":11},{\"time\":\"2021-04-03T09:36:11.000Z\",\"value\":11},{\"time\":\"2021-04-03T09:36:12.000Z\",\"value\":7},{\"time\":\"2021-04-03T09:36:13.000Z\",\"value\":7},{\"time\":\"2021-04-03T09:36:14.000Z\",\"value\":15},{\"time\":\"2021-04-03T09:36:15.000Z\",\"value\":8},{\"time\":\"2021-04-03T09:36:16.000Z\",\"value\":8}]","payloadType":"json","x":830,"y":500,"wires":[["cd794d9b.4570e"]]},{"id":"cd794d9b.4570e","type":"function","z":"83a23089.dc697","name":"reformat data for bar chart","func":"/* required format...\n[{\n    \"series\": [ \"X\" ],\n    \"data\": [ [5,6,9] ],\n    \"labels\": [ \"Jan\", \"Feb\", \"Mar\" ]\n}]\n*/\n\n/* current format...\n[{\"time\":\"2021-04-03T09:35:32.000Z\",\"value\":3}]\n*/\n\nvar influxData = msg.payload;\nmsg.influxData = influxData; //keep a copy for reference\n\nvar data = []; //an array for bar chart data values\nvar labels = []; //an array for bar chart label values\nfor (let index = 0; index < influxData.length; index++) {\n    const element = influxData[index]; //get this row of data\n    const datetime = new Date(element.time); //get the time as a datetime object\n    \n    //get HH:mm and push it into the labels\n    const time = datetime.getHours() + \":\" + datetime.getMinutes();\n    labels.push(time);\n\n    //push value into the data\n    const value = element.value;\n    data.push(value);\n}\n\n//set payload to the correct bar chart format...\nmsg.payload = [{\n    \"series\": [\"X\"],\n    \"data\": [data],\n    \"labels\": labels\n}]\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1080,"y":500,"wires":[["9e51b86c.9e1a88"]]},{"id":"9e51b86c.9e1a88","type":"debug","z":"83a23089.dc697","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":1330,"y":500,"wires":[]}]
2 Likes
7

@Steve-Mcl , Yes, data is not hourly. I injected the values to check the flow.

Will go through the demo flow & see if I understand the working :slightly_smiling_face: :+1:.

8

@Steve-Mcl , need more help. If I avoid the entire flow and directly inject the values in influxdb (ver 1.8.4). and then inject the values in chart using "last value - second last value". How should I write this query?

9

Typically just set msg.topic to a nice friendly name and msg.payload to the value then pass it into the chart. However I'm not certain what a bar chart would look like in this case it's probably more suited to a line chart or a gauge.

10

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.