Need help with line chart

Dashboard
1

Hello everyone. I'm just using node red a week ago. I can get the data from database to make a line chart but i don't know how to make a chart with multiple type of data taken from database. My flow is below. This is the first time i post so if something wrong please let me know.
P/s: sorry for my bad english and thank for reading my post :slight_smile:

 [{"id":"66115379.8c654c","type":"inject","z":"eff85edf.d773b","name":"Node 2","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":120,"y":260,"wires":[["d4a6fb67.e84f78","2fa0028b.ae6cbe","e7a983c2.03d8a"]]},{"id":"d4a6fb67.e84f78","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":260,"wires":[["121ac9a2.1faab6"]]},{"id":"ba57b212.062f1","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":260,"wires":[["78d5f82c.d03618"]]},{"id":"78d5f82c.d03618","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":260,"wires":[[]]},{"id":"121ac9a2.1faab6","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":260,"wires":[["ba57b212.062f1"]]},{"id":"2fa0028b.ae6cbe","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":320,"wires":[["83e6fc26.08287"]]},{"id":"159a0e51.2c1d42","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":320,"wires":[["84babd7d.7c9eb"]]},{"id":"84babd7d.7c9eb","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":2,"width":"6","height":"3","label":"Độ Ẩm Không Khí","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"C","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":850,"y":320,"wires":[[]]},{"id":"83e6fc26.08287","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":320,"wires":[["159a0e51.2c1d42"]]},{"id":"e7a983c2.03d8a","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Soil Humidity' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":380,"wires":[["102e2f46.495be1"]]},{"id":"b73685a7.3c5a28","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":380,"wires":[["5b436ab.507d194"]]},{"id":"5b436ab.507d194","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":3,"width":"6","height":"3","label":"Độ Ẩm Đất","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":830,"y":380,"wires":[[]]},{"id":"102e2f46.495be1","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":380,"wires":[["b73685a7.3c5a28"]]},{"id":"a8f7387.b3261c8","type":"ui_group","z":"","name":"Node 2","tab":"e070434f.c4a94","order":2,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]
2

Welcome to the forum! I'm sure as you use it more you will see what power Node-Red has.

Now to your question and first thing I'm going to ask is did you do a search of the forum using 'line chart'?
I think you might find some people who have already asked and solved this same problem.

3

If you need advance chart stuff, then take a look at Grafana.

4

Yes, I've search for solution before I post this. I know that we can get multiple data line in one chart by change the msg.topic for each type but mine is not working right. They keep change from type 1 to 2 then back to 1 then 2... But not both at the same time. :frowning: I don't know how to fix that.

5

Thanks for your reply but I didn't need that much just need three line data in one chart :smile: that enough for me.

6

What you want to achieve is explained in the below post, more specifically on the paragraph "Stored Data".
Basically you want to build 3 arrays and send them with a statement like the one below inside a function node:

msg.payload = [{"series":series, "data":data,"labels": labels}]

PS: Try out the example at the bottom of that page. You will see all kinds of line charts depicted.

nr-chart-example
nr-chart-example.png1936×919 114 KB

7

thanks but i have read it before i have already made 3 array and i don't know how to combine them into one to send to chart node.

[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["8032716f.3c6c1"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"609977c4.738c98","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":2,"width":"6","height":"3","label":"Độ Ẩm Không Khí","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"C","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":830,"y":140,"wires":[[]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a"]]},{"id":"70afd92d.e05238","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Soil Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":200,"wires":[["a92bb512.59a6d8"]]},{"id":"900388c5.5963f8","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t   {\t       \"key\": \"Độ ẩm đất\",\t       \"values\": msg.payload.[datetime,value] \t   }\t\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":200,"wires":[["b02944a1.5aa128"]]},{"id":"b02944a1.5aa128","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":3,"width":"6","height":"3","label":"Độ Ẩm Đất","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":200,"wires":[[]]},{"id":"a92bb512.59a6d8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":200,"wires":[["900388c5.5963f8"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"7a068f0d.3c43a","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t   {\t       \"key\": \"Độ ẩm không khí\",\t       \"values\": msg.payload.[datetime,value] \t   }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":140,"wires":[["609977c4.738c98"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":80,"wires":[[]]},{"id":"8032716f.3c6c1","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"Nhiệt độ\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":80,"wires":[["6f623de9.671e04"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Node 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]

Blockquote Here is my database
+----------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+----------------+
| name | text | YES | | NULL | |
| node | text | YES | | NULL | |
| datetime | datetime | YES | | NULL | |
| value | float | YES | | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
+----------+----------+------+-----+---------+----------------+

8

You have to generate a structure exactly like explained in the docs.

The object in the array is suposed to have 3 keys: "series", "data" and "labels". The values of these keys have to be arrays.

The data structure you are creating is quite different. It is not going to work (as you already realised).

[{
    "series": ["X", "Y", "Z" ],
    "data": [ [5,6,9], [3,8,5], [6,7,2] ],
    "labels": [ "Jan", "Feb", "Mar" ]
}]

[ { "key": "Độ ẩm đất", "values": msg.payload.[datetime,value]  }	]
9

Hello,

Use msg.topic to identify each type of data you are feeding to your single chart.

Regards.

10

Sorry for late reply because i have other work to do.
So i have change my code like you told me but when deploy i see 2 legend for a second and then and chart become white i don't know what wrong :frowning:
Below is my flow after change.

[{"id":"33821100.82fc8","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n    \"series\": [\"X\", \"Y\"],\n    \"data\": [ [datetemp1,temp1], [datehumi1,humi1]],\n    \"labels\": [ \"Temperature\", \"Humidity\"]\n}];\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":60,"wires":[["6f623de9.671e04"]]},{"id":"325e745e.c83dbc","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nvar temp1=msg.payload;\ndatetemp1 = datetemp1['datetime']\ntemp1 = temp1['value']\nflow.set(\"datetemp1\",datetemp1);\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":610,"y":40,"wires":[["33821100.82fc8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":940,"y":60,"wires":[[]]},{"id":"b500e753.09f3f8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nvar humi1=msg.payload;\ndatehumi1 = datehumi1['datetime']\nhumi1 = humi1['value']\nflow.set(\"datehumi1\",datehumi1);\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":610,"y":100,"wires":[["33821100.82fc8"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["325e745e.c83dbc"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a","b500e753.09f3f8"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]
11

But it seem like not work for me cause mine input is and array of data :frowning:

12

If your data is indexed to time (time-series data) then, according to the documentation, you have to transform your data structure to follow below pattern, where "x" is time and "y" is the value (temperature or humidity).

[{
"series": ["A", "B", "C"],
"data": [
    [{ "x": 1504029632890, "y": 5 },
     { "x": 1504029636001, "y": 4 },
     { "x": 1504029638656, "y": 2 }
    ],
    [{ "x": 1504029633514, "y": 6 },
     { "x": 1504029636622, "y": 7 },
     { "x": 1504029639539, "y": 6 }
    ],
    [{ "x": 1504029634400, "y": 7 },
     { "x": 1504029637959, "y": 7 },
     { "x": 1504029640317, "y": 7 }
    ]
],
"labels": [""]
}]
13

Hello mastershot24,

Andrei has illustrated an example for your case/requirement. I haven't checked where the Legend setting is overridden by the values in the labels array. In fact, the same structure is output by Line Chart as the first payload. (I don't know what the second output payload does. :worried:).

Regards.

14

I have transform data like the structure you showing me but this time the legend is stand still it not disappear anymore but the data is missing.

[{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1160,"y":160,"wires":[]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n    [{ \"x\": datetemp1, \"y\": temp1 }],\n    [{ \"x\": datehumi1, \"y\": humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":970,"y":60,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nvar humi1=msg.payload;\ndatehumi1 = datehumi1['datetime']\nhumi1 = humi1['value']\nflow.set(\"datehumi1\",datehumi1);\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":100,"wires":[["88cc3ae4.73ba48"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nvar temp1=msg.payload;\ndatetemp1 = datetemp1['datetime']\ntemp1 = temp1['value']\nflow.set(\"datetemp1\",datetemp1);\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["1d5c4cc0.255883"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a","e392ec04.b09e8"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]
15

After a few split data is not empty anymore but it still doesn't show on the chart :frowning:

[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":40,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":40,"wires":[["1d5c4cc0.255883"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":120,"wires":[["d80d042d.f2f6b8"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":120,"wires":[["e392ec04.b09e8"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238","4f5750ba.fb25c","c88d09cc.0e77d8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n    [{ \"x\": datetemp1, \"y\":temp1 }],\n    [{ \"x\": datehumi1, \"y\":humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":910,"y":100,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var temp1=msg.payload;\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var humi1=msg.payload;\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":120,"wires":[["88cc3ae4.73ba48"]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1130,"y":100,"wires":[]},{"id":"4f5750ba.fb25c","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":80,"wires":[["cbabecd.553711"]]},{"id":"cbabecd.553711","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":80,"wires":[["2f65d719.695088"]]},{"id":"2f65d719.695088","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nflow.set(\"datetemp1\",datetemp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":80,"wires":[["88cc3ae4.73ba48"]]},{"id":"5dca2d1e.adfa64","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nflow.set(\"datehumi1\",datehumi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":160,"wires":[["88cc3ae4.73ba48"]]},{"id":"c88d09cc.0e77d8","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":160,"wires":[["a9dbf147.31aa8"]]},{"id":"a9dbf147.31aa8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":160,"wires":[["5dca2d1e.adfa64"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]
16

Let´s have a look in your data:

"data": [
    [{ "x": datetemp1, "y":temp1 }],
    [{ "x": datehumi1, "y":humi1 }]
],

You have two series and only one point in each series. One point will not draw a line. This is why you don´t see a chart.

I will fake some data to explain. Below has two series (temperature and humidity) with 3 points in each series.

"data": [
    [{ "x": 1559481514470, "y":30 },{ "x": 1559481524470, "y":20 },{ "x": 1559481534470, "y":40 }],
    [{ "x": 1559481514470, "y":10 },{ "x": 1559481524470, "y":30 },{ "x": 1559481534470, "y":50 }]
],

It will display:

r-01

Flow testing:

[{"id":"7ee7e812.55f148","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"79a5afb0.61c5b","type":"ui_chart","z":"7ee7e812.55f148","name":"","group":"f27afcb9.528a8","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"9999","removeOlderPoints":"500","removeOlderUnit":"604800","cutout":0,"useOneColor":false,"colors":["#1f77b4","#ff8040","#008080","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":600,"y":100,"wires":[[]]},{"id":"912b3820.314f88","type":"function","z":"7ee7e812.55f148","name":"all","func":"\nmsg.payload= [{\n\"series\": [\"Temp\", \"Hum\"],\n\"data\": [\n    [{ \"x\": 1559481514470, \"y\":30 },{ \"x\": 1559481524470, \"y\":20 },{ \"x\": 1559481534470, \"y\":40 }],\n    [{ \"x\": 1559481514470, \"y\":10 },{ \"x\": 1559481524470, \"y\":30 },{ \"x\": 1559481534470, \"y\":50 }]\n],\n\"labels\": [\"X\", \"Y\"]\n}]\nreturn msg;\n","outputs":1,"noerr":0,"x":370,"y":140,"wires":[["79a5afb0.61c5b","cef26598.922bf8"]]},{"id":"cef26598.922bf8","type":"debug","z":"7ee7e812.55f148","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":140,"wires":[]},{"id":"1ab7b2df.d85f5d","type":"inject","z":"7ee7e812.55f148","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":140,"wires":[["912b3820.314f88"]]},{"id":"f27afcb9.528a8","type":"ui_group","z":"","name":"Khu vực 1","tab":"551dd698.ab8968","order":1,"disp":true,"width":"6","collapse":false},{"id":"551dd698.ab8968","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]
17

The data i put in each series is an array of data i selected from my data base "datatemp1" is the array of time and "temp1" is the value array. I put the debug and the result in the picture below it don't show any error but the chart is still empty.Untitled

[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":40,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":40,"wires":[["1d5c4cc0.255883"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":120,"wires":[["d80d042d.f2f6b8"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":120,"wires":[["e392ec04.b09e8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"90","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n    [{ \"x\": datetemp1, \"y\":temp1 }],\n    [{ \"x\": datehumi1, \"y\":humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":910,"y":100,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var temp1=msg.payload;\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var humi1=msg.payload;\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":120,"wires":[["88cc3ae4.73ba48"]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1130,"y":100,"wires":[]},{"id":"4f5750ba.fb25c","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":80,"wires":[["cbabecd.553711"]]},{"id":"cbabecd.553711","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":80,"wires":[["2f65d719.695088"]]},{"id":"2f65d719.695088","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nflow.set(\"datetemp1\",datetemp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":80,"wires":[["88cc3ae4.73ba48"]]},{"id":"5dca2d1e.adfa64","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nflow.set(\"datehumi1\",datehumi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":160,"wires":[["88cc3ae4.73ba48"]]},{"id":"c88d09cc.0e77d8","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":160,"wires":[["a9dbf147.31aa8"]]},{"id":"a9dbf147.31aa8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":160,"wires":[["5dca2d1e.adfa64"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238","4f5750ba.fb25c","c88d09cc.0e77d8"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]
18

The best information you can provide at this point is an example of the data generated.

Can you possibly copy the array that is generated using the debug node and post here for our analysis?

As you probably know you can copy the data (if it is not too large) using the >_ icon in the debug node.

r-01

19

payload
payload[0].data[0][0].x[0].datetime
i don't know if i do it right or not

Untitled
Untitled413×627 16.4 KB

Blockquote[{"series":["A","B"],"data":[[{"x":[{"datetime":"2019-06-03 14:46:53"},{"datetime":"2019-06-03 14:47:04"},{"datetime":"2019-06-03 14:47:15"},{"datetime":"2019-06-03 14:47:26"},{"datetime":"2019-06-03 14:48:10"},{"datetime":"2019-06-03 14:48:21"},{"datetime":"2019-06-03 14:48:38"},{"datetime":"2019-06-03 14:49:05"},{"datetime":"2019-06-03 14:49:28"},{"datetime":"2019-06-03 14:49:44"},{"datetime":"2019-06-03 14:49:55"},{"datetime":"2019-06-03 14:50:34"},{"datetime":"2019-06-03 14:51:07"},{"datetime":"2019-06-03 14:51:41"},{"datetime":"2019-06-03 14:52:08"},{"datetime":"2019-06-03 14:52:19"},{"datetime":"2019-06-03 14:52:52"},{"datetime":"2019-06-03 14:53:03"},{"datetime":"2019-06-03 14:53:31"},{"datetime":"2019-06-03 14:53:42"},{"datetime":"2019-06-03 14:53:53"},{"datetime":"2019-06-03 14:54:15"},{"datetime":"2019-06-03 14:54:26"},{"datetime":"2019-06-03 14:54:59"},{"datetime":"2019-06-03 14:55:10"},{"datetime":"2019-06-03 14:55:49"},{"datetime":"2019-06-03 14:56:00"},{"datetime":"2019-06-03 14:56:17"},{"datetime":"2019-06-03 14:56:28"},{"datetime":"2019-06-03 14:56:56"},{"datetime":"2019-06-03 14:57:23"},{"datetime":"2019-06-03 14:57:34"},{"datetime":"2019-06-03 14:57:45"},{"datetime":"2019-06-03 14:57:56"},{"datetime":"2019-06-03 14:58:07"},{"datetime":"2019-06-03 14:58:19"},{"datetime":"2019-06-03 14:58:35"},{"datetime":"2019-06-03 14:58:57"},{"datetime":"2019-06-03 14:59:08"},{"datetime":"2019-06-03 14:59:19"},{"datetime":"2019-06-03 14:59:30"},{"datetime":"2019-06-03 14:59:41"},{"datetime":"2019-06-03 14:59:53"},{"datetime":"2019-06-03 15:00:15"},{"datetime":"2019-06-03 15:00:26"},{"datetime":"2019-06-03 15:00:37"},{"datetime":"2019-06-03 15:01:43"},{"datetime":"2019-06-03 15:02:05"},{"datetime":"2019-06-03 15:02:17"},{"datetime":"2019-06-03 15:02:32"},{"datetime":"2019-06-03 15:02:47"},{"datetime":"2019-06-03 15:03:40"},{"datetime":"2019-06-03 15:04:02"},{"datetime":"2019-06-03 15:04:32"},{"datetime":"2019-06-03 15:05:10"},{"datetime":"2019-06-03 15:05:25"},{"datetime":"2019-06-03 15:06:03"},{"datetime":"2019-06-03 15:06:18"},{"datetime":"2019-06-03 15:06:56"},{"datetime":"2019-06-03 15:07:11"},{"datetime":"2019-06-03 15:07:56"},{"datetime":"2019-06-03 15:08:11"},{"datetime":"2019-06-03 15:08:26"},{"datetime":"2019-06-03 15:08:56"},{"datetime":"2019-06-03 15:09:41"},{"datetime":"2019-06-03 15:10:19"},{"datetime":"2019-06-03 15:10:34"},{"datetime":"2019-06-03 15:10:49"},{"datetime":"2019-06-03 15:11:04"},{"datetime":"2019-06-03 15:11:34"},{"datetime":"2019-06-03 15:12:12"},{"datetime":"2019-06-03 15:12:27"}],"y":[{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28}]}],[{"x":[{"datetime":"2019-06-03 14:46:53"},{"datetime":"2019-06-03 14:47:04"},{"datetime":"2019-06-03 14:47:15"},{"datetime":"2019-06-03 14:47:27"},{"datetime":"2019-06-03 14:48:10"},{"datetime":"2019-06-03 14:48:21"},{"datetime":"2019-06-03 14:48:38"},{"datetime":"2019-06-03 14:49:05"},{"datetime":"2019-06-03 14:49:28"},{"datetime":"2019-06-03 14:49:45"},{"datetime":"2019-06-03 14:49:55"},{"datetime":"2019-06-03 14:50:34"},{"datetime":"2019-06-03 14:51:07"},{"datetime":"2019-06-03 14:51:41"},{"datetime":"2019-06-03 14:52:08"},{"datetime":"2019-06-03 14:52:19"},{"datetime":"2019-06-03 14:52:52"},{"datetime":"2019-06-03 14:53:04"},{"datetime":"2019-06-03 14:53:31"},{"datetime":"2019-06-03 14:53:42"},{"datetime":"2019-06-03 14:53:53"},{"datetime":"2019-06-03 14:54:15"},{"datetime":"2019-06-03 14:54:26"},{"datetime":"2019-06-03 14:54:59"},{"datetime":"2019-06-03 14:55:10"},{"datetime":"2019-06-03 14:55:49"},{"datetime":"2019-06-03 14:56:00"},{"datetime":"2019-06-03 14:56:17"},{"datetime":"2019-06-03 14:56:28"},{"datetime":"2019-06-03 14:56:56"},{"datetime":"2019-06-03 14:57:23"},{"datetime":"2019-06-03 14:57:34"},{"datetime":"2019-06-03 14:57:45"},{"datetime":"2019-06-03 14:57:56"},{"datetime":"2019-06-03 14:58:08"},{"datetime":"2019-06-03 14:58:19"},{"datetime":"2019-06-03 14:58:35"},{"datetime":"2019-06-03 14:58:57"},{"datetime":"2019-06-03 14:59:08"},{"datetime":"2019-06-03 14:59:19"},{"datetime":"2019-06-03 14:59:30"},{"datetime":"2019-06-03 14:59:42"},{"datetime":"2019-06-03 14:59:53"},{"datetime":"2019-06-03 15:00:15"},{"datetime":"2019-06-03 15:00:26"},{"datetime":"2019-06-03 15:00:37"},{"datetime":"2019-06-03 15:01:43"},{"datetime":"2019-06-03 15:02:05"},{"datetime":"2019-06-03 15:02:17"},{"datetime":"2019-06-03 15:02:32"},{"datetime":"2019-06-03 15:02:47"},{"datetime":"2019-06-03 15:03:40"},{"datetime":"2019-06-03 15:04:02"},{"datetime":"2019-06-03 15:04:32"},{"datetime":"2019-06-03 15:05:10"},{"datetime":"2019-06-03 15:05:25"},{"datetime":"2019-06-03 15:06:03"},{"datetime":"2019-06-03 15:06:18"},{"datetime":"2019-06-03 15:06:56"},{"datetime":"2019-06-03 15:07:11"},{"datetime":"2019-06-03 15:07:56"},{"datetime":"2019-06-03 15:08:11"},{"datetime":"2019-06-03 15:08:26"},{"datetime":"2019-06-03 15:08:56"},{"datetime":"2019-06-03 15:09:41"},{"datetime":"2019-06-03 15:10:19"},{"datetime":"2019-06-03 15:10:34"},{"datetime":"2019-06-03 15:10:49"},{"datetime":"2019-06-03 15:11:04"},{"datetime":"2019-06-03 15:11:35"},{"datetime":"2019-06-03 15:12:12"},{"datetime":"2019-06-03 15:12:27"}],"y":[{"value":78},{"value":78},{"value":77},{"value":77},{"value":78},{"value":79},{"value":79},{"value":80},{"value":80},{"value":80},{"value":80},{"value":80},{"value":80},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":77},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":76},{"value":77},{"value":76},{"value":77},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":77},{"value":76}]}]],"labels":[""]}]

20

I told you to copy the data using the icon >_ but this is not correct. You want to use the other icon that appears on the side.

r-01

The data you shared is the one that is being injected in the ui_chart?

The ui_chart will only display the chart if the data respects the expected format where each point is an object with the "x" key holding the date (timestamp format) and the key "y" holding the value.

{ "x": 1504029632890, "y": 5 }

Apparently, the data your flow is injecting in the ui_chart node is not formatted correctly.