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 sheets of the excel file. For example : Sensor 1 values with time stamp should be filtered and saved to sheet 1 and Sensor 2 values with timestamp should be filtered and saved to sheet 2 from MSSQL and so on. I can filter the data from MSSQL but I am not able to create different sheets for different tags.
I want to create a real time graph between temperature and pressure. Both the parameters is a real time parameters. I do not want to have time in the X-axis.
If I am able to create these two things the major task of my project will be complete. Please help me to achieve this.