5 Replies Latest reply on Jun 13, 2016 10:11 AM by Gabriella Chandra

    Display per Shift View

    Gabriella Chandra

      Hi All!

      I have a set of data that is being collected every minute as seen below. However, I want to display the time in green/yellow/yellow by shift instead of per hour or per day.

       

      Shifts are as follows:

      Shift 1 7AM-3PM

      Shift 2 3PM-11PM

      Shift 3 11PM-7AM

       

      How do I calculate this easily and cleanly?

       

      Thanks!

       

         

      Process 1yellow/flashing6/6/2016 10:18
      Process 1yellow/flashing6/6/2016 10:19
      Process 1yellow/flashing6/6/2016 10:20
      Process 1yellow6/6/2016 10:21
      Process 1yellow/flashing6/6/2016 10:22
      Process 1yellow/flashing6/6/2016 10:23
      Process 1yellow/flashing6/6/2016 10:24
      Process 1yellow/flashing6/6/2016 10:25
      Process 1yellow/flashing6/6/2016 10:26
      Process 1green6/6/2016 10:27
      Process 1green6/6/2016 10:28
      Process 1green6/6/2016 10:29
      Process 1green6/6/2016 10:30