Hi all, and thank you in advance. I've been searching before, but I don't find any entry with white pie chart problem.
I want to output in dashboard 3 values with two charts, bar chart and pie chart. The output is the same. I don't understand why with the bar chart the colors are shown perfect and with the pie chart is all white.
I attach the NR code:
[{"id":"6d3f8d5c.819c04","type":"inject","z":"9e72b951.02dc78","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"3600","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":150,"y":400,"wires":[["f9b88668.7bfa78"]]},{"id":"f9b88668.7bfa78","type":"function","z":"9e72b951.02dc78","name":"","func":"var newMsg = {\"topic\": \"SELECT * FROM ContKwh ORDER BY Ind DESC LIMIT 2\"}\nreturn newMsg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":350,"y":400,"wires":[["80ed1d44.ef78f"]]},{"id":"80ed1d44.ef78f","type":"mysql","z":"9e72b951.02dc78","mydb":"dd185369.7a13b","name":"","x":520,"y":400,"wires":[["e4d9597a.4254e8"]]},{"id":"e4d9597a.4254e8","type":"function","z":"9e72b951.02dc78","name":"","func":"var KwCasaUltimDia= msg.payload[0].KwhX1-msg.payload[1].KwhX1;\nvar KwFVUltimDia= msg.payload[0].KwhFV1-msg.payload[1].KwhFV1;\nvar KWFecsaUltimDia= msg.payload[0].KwhX1-msg.payload[0].KwhFV1;\nvar m={},label,data;\nm.series=[];\nm.labels=['FV','Companyia','Consum'];\nm.data=[KwFVUltimDia,KWFecsaUltimDia,KwCasaUltimDia];\n\nreturn {payload:[m]};","outputs":1,"noerr":0,"initialize":"","finalize":"","x":680,"y":400,"wires":[["a04080da.3c40d","b68dd83c.2f1da8"]]},{"id":"a04080da.3c40d","type":"ui_chart","z":"9e72b951.02dc78","name":"","group":"aa43db30.ce1298","order":8,"width":6,"height":5,"label":"Kw Dia Consum","chartType":"bar","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":true,"useUTC":false,"colors":["#47ee44","#f8f00d","#0fe3ff","#2da92d","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"x":870,"y":400,"wires":[[]]},{"id":"b68dd83c.2f1da8","type":"ui_chart","z":"9e72b951.02dc78","name":"","group":"aa43db30.ce1298","order":9,"width":6,"height":5,"label":"Kw Dia Consum","chartType":"pie","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":"70","useOneColor":true,"useUTC":false,"colors":["#47ee44","#f8f00d","#0fe3ff","#2da92d","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"x":870,"y":440,"wires":[[]]},{"id":"dd185369.7a13b","type":"MySQLdatabase","name":"","host":"127.0.0.1","port":"3306","db":"fvdb","tz":"","charset":""},{"id":"aa43db30.ce1298","type":"ui_group","name":"Gràfics","tab":"7605e0c6.2cdf9","order":1,"disp":true,"width":12,"collapse":false},{"id":"7605e0c6.2cdf9","type":"ui_tab","name":"Anàlisi Gràfic","icon":"dashboard","order":37,"disabled":false,"hidden":false}]
Best Regards!
Pau