5 Replies Latest reply: Feb 15, 2018 9:50 AM by Tracy Crown RSS

    Count By Date & Hour

    Tracy Crown

      Dear Sir/Madam

       

      I am trying to compute number of students coming to exam hall at different time interval (ie. In time) and group them under the time table below.

       

      I faced problem to present the results By Date (280) and By Hour(285), you can see that both charts generate different answers. Also, the result in charts is different from reports (165 vs 266).

       

      Kindly help to advise which one is the correct answer (165 ?)

       

      Thank you

      Tracy  

       

       

      Start_HourEnd_HourPaperNumber of Students
      10.30 11.30 Finance?
      11.30 12.30 Finance?
      12.30 13.30 Finance?
      13.30 14.30 Tea Break?
      14.30 15.30 Social Science?
      15.30 16.30 Social Science?
      16.30 17.30 Tea Break?
      17.30 18.30 Mathematics?
      18.30 19.30 Mathematics?
      19.30 20.30 Teak Break?
      20.30 21.30 English?
      21.30 22.30 English

      ?