Re: [Koha] tiny bit of help needed with report

Hello Lisa, You may try following: SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day, HOUR(statistics.datetime) AS Hour, count(*) AS Checkouts FROM statistics left join items on statistics.itemnumber=items.itemnumber WHERE statistics.dat

Re: [Koha] tiny bit of help needed with report

.ha...@gmail.com" Date: Friday, 15 May 2020 at 16:13 To: Lisa Peel Cc: "koha@lists.katipo.co.nz" Subject: Re: [Koha] tiny bit of help needed with report Hi Lisa, If you're just looking to use the branch column in statistics you can add it to your select list and then to th

Re: [Koha] tiny bit of help needed with report

Hi Lisa, If you're just looking to use the branch column in statistics you can add it to your select list and then to the group by. So the select line would become something like this: SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day,

[Koha] tiny bit of help needed with report

Hello I apologise for the simplicity of this question but could really use some help. I want to use the Hourly report in the KOHA wiki for ‘Checkouts by Hour in Selected Date Range’ as below SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime)