Hi I have two basic requirements which I am not able to do it. I will list my issues in points. I want to create a report. I can log data from various sensors to MSSQL and from MSSQL to excel file using node-red successfully. I want to filter the data based on sensor tags and save it separate sh…

I don't think there is an easy way of creating separate sheets in an excel file with the currently available nodes. Point 2 you asked the same question 13 days ago, and received a reply that explained how to do it Graph or chart for real time variables I moved your post into the #general as it was…

[image] asharm0502: I want to filter the data based on sensor tags and save it separate sheets of the excel file Rather than trying to do this directly with Excel, it is very likely to be easier to use 2 separate CSV files and then create an Excel workbook that uses PowerQuery to combine the …

I checked Grafana and it looks interesting. Thank you for that. The graph which I want to look is a real time graph between temperature and pressure and both these data are coming from PLC. I am checking the behavior of the system in real time.

[image] asharm0502: I am checking the behavior of the system in real time. Well real-time means different things to different people of course. To get closest to real real-time, you should receive the data direct from the devices rather than via a db. If I had the choice of architecture, I wo…

Currently I am receiving data directly from my PLC devices and then I am storing it to MSSQL. But node-red doesn't give any option to plot the real time data for two different parameters( pressure vs Temperature)

Ah, sorry, I misunderstood. There are several ways you could do that depending on what you already have in use. If you are using Dashboard for other things, you can add custom code via the template node so if you can find a suitable chart library, that is easily included. If you aren't using Dash…

Node-RED

Node-RED Forum

Reporting and Graph

General

drmibell 10 April 2019 02:11 8

I haven't tried it, but it sounds like the flow linked in this discussion might work for you: Has anyone created a scatter/bubble plot?

Topic		Replies	Views
Excel to node red General	8	4263	16 April 2020
Create a formatted Excel Report with node red Dashboard	3	824	18 September 2022
Saving MQTT JSON data to an excel spreadsheet General	9	3615	10 May 2020
Aggregating sensor data with time stamp to save in excel General	13	2447	4 February 2020
Click PLC information to Excel General	2	450	8 October 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Reporting and Graph

Related topics