Koha has a very robust SQL-based reporting module, so generating statistics like these is generally a fairly routine process.
This report lists the top 10 circulating items in the last 6 months, for example --
SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode
FROM statistics s
JOIN items i ON (i.itemnumber=s.itemnumber)
LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber)
WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL
GROUP BY b.biblionumber
ORDER BY circs DESC
LIMIT 10
Constantly growing list of user-contributed reports here:
http://wiki.koha-community.org/wiki/SQL_Reports_Library/
Can't speak to Aleph, but there is a Developer's Network which should point you in the right direction:
https://developers.exlibrisgroup.com/
Best,
Cab Vinton
Plaistow Public Library
|