4 Replies Latest reply on Sep 24, 2018 4:51 PM by Shinichiro Murakami

    Counting Jobs completed and started by hour

    Scott Kolar

      Discharge complete = job complete

      discharged confirmed = job start

       

      In the first sheet I use job completed as the time scale.  Then I dragged both job completed and job started onto that time scale to get the number of completed jobs and started jobs for each hour of the day. This caused the number of jobs completed and jobs started numbers to be essentially the same.

       

      1.PNG

       

      However when I used two separate sheets and used job complete as the timescale for the number of job completes, and job started as the timescale for the number of jobs started the numbers are completely different.  Any ideas on what is causing this and is there a way to create a generic timescale (0 to 23 hours).

       

      2.PNG1.PNG