Hello there!
Need help,
I want to display data of 31 days on graph. Now, value 0 is also there. I have used change node to set topic for all the coming input value and then output of all change node is given to join node. whenever null arrives it gives error. I am attaching a flow (same way I have done for 31) and screenshot below....
How I can deal with null values?
[{"id":"9086171b.177a28","type":"change","z":"3cd5e940.384eb6","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"day20","tot":"str"},{"t":"set","p":"payload","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1717.3334274291992,"y":1333.3334140777588,"wires":[["27107a10.dde5a6"]]},{"id":"19183557.b0d77b","type":"change","z":"3cd5e940.384eb6","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"day21","tot":"str"},{"t":"set","p":"payload","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1734.333423614502,"y":1403.3334147930145,"wires":[["27107a10.dde5a6"]]},{"id":"7ad924f5.afd5dc","type":"change","z":"3cd5e940.384eb6","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"day22","tot":"str"},{"t":"set","p":"payload","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1729.333423614502,"y":1450.3334159851074,"wires":[["27107a10.dde5a6"]]},{"id":"ac221539.abd3b8","type":"function","z":"3cd5e940.384eb6","name":"","func":"const date = new Date();\n\nlet day = date.getDate();\nlet day2 = 20;\n//let yesterday = date.getDate() -1 ;\nlet month = date.getMonth() + 1;\nlet year = date.getFullYear();\n\nlet yesterDate = `${year}-${month}-${day2} 00:00:01`;\nlet currentDate = `${year}-${month}-${day2} 23:59:59`;\n\nmsg.from=new Date(yesterDate).toISOString();\nmsg.to=new Date(currentDate).toISOString();\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1169.3643913269043,"y":1333.880160331726,"wires":[["2db89fa0.042ba"]],"outputLabels":["From"]},{"id":"ab16d700.d6b9a8","type":"function","z":"3cd5e940.384eb6","name":"","func":"const date = new Date();\n\nlet day = date.getDate();\nlet day3 = 21;\n//let yesterday = date.getDate() -1 ;\nlet month = date.getMonth() + 1;\nlet year = date.getFullYear();\n\nlet yesterDate = `${year}-${month}-${day3} 00:00:01`;\nlet currentDate = `${year}-${month}-${day3} 23:59:59`;\n\nmsg.from=new Date(yesterDate).toISOString();\nmsg.to=new Date(currentDate).toISOString();\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1173.3643913269043,"y":1402.880160331726,"wires":[["3caa5f10.f2b86"]],"outputLabels":["From"]},{"id":"ee984f19.64ed","type":"function","z":"3cd5e940.384eb6","name":"","func":"//return { payload: msg.payload[0].Agg1_Total_Weight.minvalue }\nlet array_length = msg.payload.aggregates.length;\nvar j,y;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg1_Total_Weight== null || msg.payload.aggregates[i].Agg1_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg1 = 0;\nconst maxvalue_Agg1 = 0;\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg1 = msg.payload.aggregates[j].Agg1_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg1_Total_Weight.maxvalue<=minvalue_Agg1)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg1 = msg.payload.aggregates[y].Agg1_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg2_Total_Weight== null || msg.payload.aggregates[i].Agg2_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg2 = 0;\nconst maxvalue_Agg2 = 0;\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg2 = msg.payload.aggregates[j].Agg2_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg2_Total_Weight.maxvalue<=minvalue_Agg2)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg2 = msg.payload.aggregates[y].Agg2_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg3_Total_Weight== null || msg.payload.aggregates[i].Agg3_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg3 = 0;\nconst maxvalue_Agg3 = 0;\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg3 = msg.payload.aggregates[j].Agg3_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg3_Total_Weight.maxvalue<=minvalue_Agg3)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg3 = msg.payload.aggregates[y].Agg3_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg4_Total_Weight== null || msg.payload.aggregates[i].Agg4_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg4 = 0;\nconst maxvalue_Agg4 = 0;\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg4 = msg.payload.aggregates[j].Agg4_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg4_Total_Weight.maxvalue<=minvalue_Agg4)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg4 = msg.payload.aggregates[y].Agg4_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Bitumen_Total_Weight== null || msg.payload.aggregates[i].Bitumen_Total_Weight=== 'undefined')\n{\nconst minvalue_Bitumen = 0;\nconst maxvalue_Bitumen = 0;\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n}\nelse\n{\nj=i;\n\nvar minvalue_Bitumen = msg.payload.aggregates[j].Bitumen_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Bitumen_Total_Weight.maxvalue<=minvalue_Bitumen)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Bitumen = msg.payload.aggregates[y].Bitumen_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Filler_Total_Weight== null || msg.payload.aggregates[i].Filler_Total_Weight=== 'undefined')\n{\nconst minvalue_Filler = 0;\nconst maxvalue_Filler = 0;\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n}\nelse\n{\nj=i;\n\nvar minvalue_Filler = msg.payload.aggregates[j].Filler_Total_Weight.minvalue;\n /* if(msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue>minvalue_Filler)\n {\n var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n var difference_Filler= maxvalue_Filler-minvalue_Filler;\n }\n else\n {\n var difference= 1;\n }*/\n//const maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n//var difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Filler_Total_Weight.maxvalue<=minvalue_Filler)\n{\n //var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n //break;\n}\nelse\n{\n y=x;\n var maxvalue_Filler = msg.payload.aggregates[y].Filler_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nconst Total= difference_Agg1+difference_Agg2+difference_Agg3+difference_Agg4+difference_Bitumen+difference_Filler;\n\nmsg.payload =Total;\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1536.7134017944336,"y":1337.9869327545166,"wires":[["9086171b.177a28"]]},{"id":"12b7ce6a.ff3a42","type":"function","z":"3cd5e940.384eb6","name":"","func":"//return { payload: msg.payload[0].Agg1_Total_Weight.minvalue }\nlet array_length = msg.payload.aggregates.length;\nvar j,y;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg1_Total_Weight== null || msg.payload.aggregates[i].Agg1_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg1 = 0;\nconst maxvalue_Agg1 = 0;\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg1 = msg.payload.aggregates[j].Agg1_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg1_Total_Weight.maxvalue<=minvalue_Agg1)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg1 = msg.payload.aggregates[y].Agg1_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg2_Total_Weight== null || msg.payload.aggregates[i].Agg2_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg2 = 0;\nconst maxvalue_Agg2 = 0;\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg2 = msg.payload.aggregates[j].Agg2_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg2_Total_Weight.maxvalue<=minvalue_Agg2)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg2 = msg.payload.aggregates[y].Agg2_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg3_Total_Weight== null || msg.payload.aggregates[i].Agg3_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg3 = 0;\nconst maxvalue_Agg3 = 0;\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg3 = msg.payload.aggregates[j].Agg3_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg3_Total_Weight.maxvalue<=minvalue_Agg3)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg3 = msg.payload.aggregates[y].Agg3_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg4_Total_Weight== null || msg.payload.aggregates[i].Agg4_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg4 = 0;\nconst maxvalue_Agg4 = 0;\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg4 = msg.payload.aggregates[j].Agg4_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg4_Total_Weight.maxvalue<=minvalue_Agg4)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg4 = msg.payload.aggregates[y].Agg4_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Bitumen_Total_Weight== null || msg.payload.aggregates[i].Bitumen_Total_Weight=== 'undefined')\n{\nconst minvalue_Bitumen = 0;\nconst maxvalue_Bitumen = 0;\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n}\nelse\n{\nj=i;\n\nvar minvalue_Bitumen = msg.payload.aggregates[j].Bitumen_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Bitumen_Total_Weight.maxvalue<=minvalue_Bitumen)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Bitumen = msg.payload.aggregates[y].Bitumen_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Filler_Total_Weight== null || msg.payload.aggregates[i].Filler_Total_Weight=== 'undefined')\n{\nconst minvalue_Filler = 0;\nconst maxvalue_Filler = 0;\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n}\nelse\n{\nj=i;\n\nvar minvalue_Filler = msg.payload.aggregates[j].Filler_Total_Weight.minvalue;\n /* if(msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue>minvalue_Filler)\n {\n var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n var difference_Filler= maxvalue_Filler-minvalue_Filler;\n }\n else\n {\n var difference= 1;\n }*/\n//const maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n//var difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Filler_Total_Weight.maxvalue<=minvalue_Filler)\n{\n //var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n //break;\n}\nelse\n{\n y=x;\n var maxvalue_Filler = msg.payload.aggregates[y].Filler_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nconst Total= difference_Agg1+difference_Agg2+difference_Agg3+difference_Agg4+difference_Bitumen+difference_Filler;\n\nmsg.payload =Total;\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1541.7134017944336,"y":1405.9869327545166,"wires":[["19183557.b0d77b"]]},{"id":"7a91250e.0323ac","type":"function","z":"3cd5e940.384eb6","name":"","func":"const date = new Date();\n\nlet day = date.getDate();\nlet day1 = 22;\n//let yesterday = date.getDate() -1 ;\nlet month = date.getMonth() + 1;\nlet year = date.getFullYear();\n\nlet yesterDate = `${year}-${month}-${day1} 00:00:01`;\nlet currentDate = `${year}-${month}-${day1} 23:59:59`;\n\nmsg.from=new Date(yesterDate).toISOString();\nmsg.to=new Date(currentDate).toISOString();\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1175.7134017944336,"y":1455.9869327545166,"wires":[["6e6a82ff.822b5c"]],"outputLabels":["From"]},{"id":"5f015f7e.b6f37","type":"function","z":"3cd5e940.384eb6","name":"","func":"//return { payload: msg.payload[0].Agg1_Total_Weight.minvalue }\nlet array_length = msg.payload.aggregates.length;\nvar j,y;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg1_Total_Weight== null || msg.payload.aggregates[i].Agg1_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg1 = 0;\nconst maxvalue_Agg1 = 0;\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg1 = msg.payload.aggregates[j].Agg1_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg1_Total_Weight.maxvalue<=minvalue_Agg1)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg1 = msg.payload.aggregates[y].Agg1_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg1= maxvalue_Agg1-minvalue_Agg1;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg2_Total_Weight== null || msg.payload.aggregates[i].Agg2_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg2 = 0;\nconst maxvalue_Agg2 = 0;\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg2 = msg.payload.aggregates[j].Agg2_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg2_Total_Weight.maxvalue<=minvalue_Agg2)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg2 = msg.payload.aggregates[y].Agg2_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg2= maxvalue_Agg2-minvalue_Agg2;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg3_Total_Weight== null || msg.payload.aggregates[i].Agg3_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg3 = 0;\nconst maxvalue_Agg3 = 0;\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg3 = msg.payload.aggregates[j].Agg3_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg3_Total_Weight.maxvalue<=minvalue_Agg3)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg3 = msg.payload.aggregates[y].Agg3_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg3= maxvalue_Agg3-minvalue_Agg3;\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Agg4_Total_Weight== null || msg.payload.aggregates[i].Agg4_Total_Weight=== 'undefined')\n{\nconst minvalue_Agg4 = 0;\nconst maxvalue_Agg4 = 0;\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n}\nelse\n{\nj=i;\n\nvar minvalue_Agg4 = msg.payload.aggregates[j].Agg4_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Agg4_Total_Weight.maxvalue<=minvalue_Agg4)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Agg4 = msg.payload.aggregates[y].Agg4_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Agg4= maxvalue_Agg4-minvalue_Agg4;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Bitumen_Total_Weight== null || msg.payload.aggregates[i].Bitumen_Total_Weight=== 'undefined')\n{\nconst minvalue_Bitumen = 0;\nconst maxvalue_Bitumen = 0;\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n}\nelse\n{\nj=i;\n\nvar minvalue_Bitumen = msg.payload.aggregates[j].Bitumen_Total_Weight.minvalue;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Bitumen_Total_Weight.maxvalue<=minvalue_Bitumen)\n{\n\n}\nelse\n{\n y=x;\n var maxvalue_Bitumen = msg.payload.aggregates[y].Bitumen_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Bitumen= maxvalue_Bitumen-minvalue_Bitumen;\n\n////\n\nfor(var i=0;i<array_length;i++)\n{\nif(msg.payload.aggregates[i].Filler_Total_Weight== null || msg.payload.aggregates[i].Filler_Total_Weight=== 'undefined')\n{\nconst minvalue_Filler = 0;\nconst maxvalue_Filler = 0;\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n}\nelse\n{\nj=i;\n\nvar minvalue_Filler = msg.payload.aggregates[j].Filler_Total_Weight.minvalue;\n /* if(msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue>minvalue_Filler)\n {\n var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n var difference_Filler= maxvalue_Filler-minvalue_Filler;\n }\n else\n {\n var difference= 1;\n }*/\n//const maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n//var difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nbreak;\n}\n}\n\nfor(var x=(array_length - 1);x>=0;x--)\n{\nif(msg.payload.aggregates[x].Filler_Total_Weight.maxvalue<=minvalue_Filler)\n{\n //var maxvalue_Filler = msg.payload.aggregates[array_length - 1].Filler_Total_Weight.maxvalue;\n //break;\n}\nelse\n{\n y=x;\n var maxvalue_Filler = msg.payload.aggregates[y].Filler_Total_Weight.maxvalue;\n break;\n}\n}\n\nvar difference_Filler= maxvalue_Filler-minvalue_Filler;\n\nconst Total= difference_Agg1+difference_Agg2+difference_Agg3+difference_Agg4+difference_Bitumen+difference_Filler;\n\nmsg.payload =Total;\nreturn msg;\n\n\n\n","outputs":"1","language":"javascript","noerr":0,"x":1534.062313079834,"y":1457.0936861038208,"wires":[["7ad924f5.afd5dc"]]},{"id":"2db89fa0.042ba","type":"http request","z":"3cd5e940.384eb6","name":"","method":"GET","ret":"obj","url":"","timeout":"0","mindspherePath":"/api/iottsaggregates/v4/aggregates?assetId=ded1a0bfec43400f970e566f8263c6d3&aspectName=BatchMix&from={{{from}}}&to={{{to}}}&intervalUnit=hour&intervalValue=1&select=Agg1_Total_Weight,Agg2_Total_Weight,Agg3_Total_Weight,Agg4_Total_Weight,Bitumen_Total_Weight,Filler_Total_Weight","useMindsphereAuth":true,"isAdmin":false,"x":1366.4635219573975,"y":1336.986927986145,"wires":[["ee984f19.64ed"]]},{"id":"3caa5f10.f2b86","type":"http request","z":"3cd5e940.384eb6","name":"","method":"GET","ret":"obj","url":"","timeout":"0","mindspherePath":"/api/iottsaggregates/v4/aggregates?assetId=ded1a0bfec43400f970e566f8263c6d3&aspectName=BatchMix&from={{{from}}}&to={{{to}}}&intervalUnit=hour&intervalValue=1&select=Agg1_Total_Weight,Agg2_Total_Weight,Agg3_Total_Weight,Agg4_Total_Weight,Bitumen_Total_Weight,Filler_Total_Weight","useMindsphereAuth":true,"isAdmin":false,"x":1371.4635219573975,"y":1404.986927986145,"wires":[["12b7ce6a.ff3a42"]]},{"id":"6e6a82ff.822b5c","type":"http request","z":"3cd5e940.384eb6","name":"","method":"GET","ret":"obj","url":"","timeout":"0","mindspherePath":"/api/iottsaggregates/v4/aggregates?assetId=ded1a0bfec43400f970e566f8263c6d3&aspectName=BatchMix&from={{{from}}}&to={{{to}}}&intervalUnit=hour&intervalValue=1&select=Agg1_Total_Weight,Agg2_Total_Weight,Agg3_Total_Weight,Agg4_Total_Weight,Bitumen_Total_Weight,Filler_Total_Weight","useMindsphereAuth":true,"isAdmin":false,"x":1363.8124332427979,"y":1456.0936813354492,"wires":[["5f015f7e.b6f37"]]},{"id":"27107a10.dde5a6","type":"join","z":"3cd5e940.384eb6","name":"","mode":"custom","build":"merged","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"31","x":2064.000244140625,"y":1402.0004081726074,"wires":[["fddda084.4e922"]]}]
