[Koha] Time-based Circulation Statistics

Katrin Fischer katrin.fischer.83 at web.de
Tue Sep 3 17:29:32 NZST 2019


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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha


More information about the Koha mailing list