Thank you Steve.. I own you huge hug for your tutorial.. I spend many hours to figure it out how to work with chart and python is my baseland so was difficult to me understand the principal and correct coding.
@@stevecope Hello, yes, it is missing. The flows from that website has only 4-5 nodes, whereas the last flow you showed in this video seems complex and has more nodes. Is it possible to have the flow of that? Thank you
@@stevecope Thanks! I was trying to use "alafile in" to read an excel file and then use the ui-chart to create a chart but it gives an error "Bad data inject"
Hi Sorry but I don't have the data files any more if you use the ask steve page on the site and send me your data files I will take a look. stevesnoderedguide.com/ask-steve Rgds Steve
Hello, first thnak u for ur useful viedo. i have a question. I want to convert csv.file to chart and i used ur codes. now i have Error: Cannot read property "split" of undefined. I tested some another Codes but dont resolve. Can u please say me , what can i do? Tnx alot
@@sujitjana2155 Go to the site and use the ask steve page and then you can send me the flow and I will take a look. www.steves-internet-guide.com/ask-steve/
Been struggling with creating charts from CSV for some time. Your help with this is most welcome. Many thanks. Arthur
same to me! thanks god that i found this gay
Hi
The flows are here
stevesnoderedguide.com/download/chart-log-csv-flow
www.steves-internet-guide.com/download/chart-log-video/
rgds
steve
well that was taking me forever and getting no where until I found your excellent tutorial. I would have never worked it out on my own. Thanks Steve
No problem. Glad to have helped .
Rgds
Steve
Steve, thank you for the tutorial. I always enjoy your work.
Thank you Steve.. I own you huge hug for your tutorial.. I spend many hours to figure it out how to work with chart and python is my baseland so was difficult to me understand the principal and correct coding.
HI! is it also possible to use a bar graph instead of lines?
Hello Steve, excelent tutorial, thank you. Can you share the flow for the last UI you showed in this video? That will be very helpful, thank you
You should find the flows on this page
stevesnoderedguide.com/using-the-node-red-chart-node
have you tried it or is one missing from there?
Rgds
Steve
@@stevecope Hello, yes, it is missing. The flows from that website has only 4-5 nodes, whereas the last flow you showed in this video seems complex and has more nodes. Is it possible to have the flow of that? Thank you
'@@EPC2036 I'll see if I can find it. Where in the video does it appear?
Rgds
Steve
@@stevecope Hello Steve, around the 10:40 mark
I did that flow for someone a long time ago I will just check that there is nothing confidential in it and put a link to it.
Rgds
Steve
thanks a lot sir but i'm confused about something
is the timestamp you're making the same as the X-axis of the chart ?
thanks a lot .
The date function is wrong. Don't divide datum by 1000.
do you need to convert to UTC in order to show the data to graph?
No but you need the time in milliseconds not Unix time
@@stevecope thank you Steve, now working!
very helpful. Thank you sir
Helped me a lot. Thank you!!!!
Really nice video! Thanks Steve! I have a question, how do we create a chart from an excel file in node red?
Export it as a csv file and use that as in the example.
@@stevecope Thanks! I was trying to use "alafile in" to read an excel file and then use the ui-chart to create a chart but it gives an error "Bad data inject"
@Steve Cope can you please share the csv file that you have used in this video?
@@bibekkabi4986 Here it is stevesnoderedguide.com/download/example-csv-for-video
@@stevecope Thanks a lot!
Hi, as I am using your flow as reference, I notice the time is not showing accurately. It is not even updating for me. What could be the issue?
The date function is wrong. Don't divide datum by 1000.
Hello, has anyone solved the issue with the "split"? Thanks.
Not aware of the issue can you remind me.
Rgds
Steve
thanks for share !!! :) i love nodered
their is error at split , please help to fix
I'll take a look
Rgds
Steve
Hi
Sorry but I don't have the data files any more if you use the ask steve page on the site and send me your data files I will take a look.
stevesnoderedguide.com/ask-steve
Rgds
Steve
Hello, first thnak u for ur useful viedo. i have a question. I want to convert csv.file to chart and i used ur codes. now i have Error: Cannot read property "split" of undefined. I tested some another Codes but dont resolve. Can u please say me , what can i do? Tnx alot
Hi
If you go to stevesnoderedguide.com/ask-steve and get in touch you can then send me the flow and data via email and I will take a look.
Rgds
Steve
@@stevecope sir exactly i have same problem. Now what to do?
@@sujitjana2155 Go to the site and use the ask steve page and then you can send me the flow and I will take a look.
www.steves-internet-guide.com/ask-steve/
Thanks!
Simple version
var row = {
"series": ["Living", "Outside", "Office" ],
"data": [], //"data": [ {x,y}] ]
"labels":[]//["Living Temp", "Outside Temp", "Office Temp" ]
};
var msg1 = {};
var pll = msg.payload.length;
//pll = 5;
var array = [];
row.series.forEach(function(item){
array = [];
var data = [];
//EACH DB ROW
for(let i = 0; i < pll; i++)
{
var DBrow = msg.payload[i];
data.push({x:DBrow['dt'].getTime(), y:parseFloat(DBrow[item])});
//node.warn(data);
}
row.data.push(data);
array.push(row);
});
msg1.payload = array;
return msg1;