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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
