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

# Count By Date & Hour

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_Hour End_Hour Paper Number 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 ?
• ###### Re: Count By Date & Hour

If you can explain the result set, That may great help us to reply

• ###### Re: Count By Date & Hour

Dear Mr Anil Babu

For example, Student# 1004 came to exam hall at 12.15pm so the system should count 1 in the time table 11.30 - 12.30. The correct answer should be 165 (see Attendance Report By Date).

The problem is why Attendance Report By Hour and Charts (Table 1 & Table 2) showed different results.

Thank You

Tracy

• ###### Re: Count By Date & Hour

But, There is nothing called "Exam Hall". Will you provide output if you know from provided table

• ###### Re: Count By Date & Hour

Dear Mr Anil Babu

The data is simply for one exam hall (ie. Morris).

Tracy

• ###### Re: Count By Date & Hour

Dear all

Can someone help on this grouping issue ?.

Thank you so much

Tracy