[Koha] Time-based Circulation Statistics

[Katrin Fischer]

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