Data 1 ----Need to show the trend by machine, for example, every machine have like the trend of stop and start (here mostly machine stops between 23:00 to 6:00 because there is no shift) 2 ----If you look at machine no 4 it stops between the shifts on 28th Feb but no other machine stops (this is a FALSE STOP because of break down)3 -----On 2nd of march all the machines stops and starts at the same time between shift (this is considered as a TRUE stop because of maintenance)
What I tried I have calculated interval between stop and start time have seperated dates and time, tried class function for time bucket but did not help.
Requirement and condition 1---- My requirement is to show some kind of trend with respect to machine numbers so that the user could visually understand by pattern if it is a TRUE stop or a FALSE stop (it should also have a 10 min threshold for example if machine1 stops at 10:10, and machine 2,and 3 at 10:20 and machine 4 and 5 at 9:55 it should be TRUE as well) 2 -----Can someone help me with logic to achieve this in a table and graph (I was thinking of a bar graph Y-axis would be time from 00:00 to 11:55 and X-axis with Machine number and the stop duration shows in RED and others in Blue, but not able to think of any logic to achieve it) 3 -----Please suggest if there is any better way of visualizing the trend other than the above.
