Hello friends,
I need to monitor machine condition through graph. I took machine data from MySQL database. I want to display daily machine on/off operating status graph using reporting module.
Machine Working Hours : 10:00 AM to 07:00 PM
Machine Non-Working Hours: 07:00 PM to 10:00 AM
Machine Tag: Bool (1/0) Data is logged in the database as 0(OFF) and 1(ON) format.
If the data is logged during working hours and then chart will appear in green colour if the data is logged during non-working hours and then the chart will appear in red colour.
The both working and non working hour data should be in one graph.
Report format.
