Hi Admire, what you can do is use the timestamps in the statistics table and group by them. The reports library has some circulation in the 'hourly' section that might give you a good starting point: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Hourly Hope this helps, Katrin On 01.09.19 15:47, Admire Mutsikiwa wrote:
Hi
We are interested in generating circulation statistics grouping then by hour of day so that we can establish the busiest times for circulation activities. I will appreciate any pointers on coming with such a SQL report.
Kind Regards,
Admire Mutsikiwa _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha