Adding recent (current/past year) statistics to the items table
Hi All, We have had several requests recently for an easy way to access current/last year's circulation stats for items, without having to create reports totalling these numbers. The numbers here are used for weeding, state reporting, etc. Other systems have fields: 'Year to date circ' and 'last year circ' We have discussed several possible developments: - a new table to track these - adding a new field, or altering 'issues' to use JSON and storing circ/renewal counts by year - adding two new fields to the items table and use a cronjob to move 'current year' circ to 'last years circ' at the end of the year. We wanted to check in with the community to see if this is a request that others have or have seen, and how they handle these. Thanks for any info. Nick (kidclamp) -- Nick Clemens ByWater Solutions bywatersolutions.com Phone: (888) 900-8944 Pronouns: (he/him/his) Timezone: Eastern Follow us: <https://www.facebook.com/ByWaterSolutions/> <https://www.instagram.com/bywatersolutions/> <https://www.youtube.com/user/bywatersolutions> <https://twitter.com/ByWaterSolution>
Hi Nick,
From my experience with stats -not only regarding libraries- there is always someone who needs it the other way... ie some will want by months, weeks, year, some by A, others by B and C, etc. this is endlessly.
IMHO a table with different counters keyed by a timestamp where the user can define periodicity will ease enough staff creating their own stat reports. i.e. staff will define how often stat will be added to the stats table by a cronjob. It might also be possible to have a way to staff to select which counters to collect/add into stats table. Hope this makes sense, Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 22 avr. 2022 à 13:52, Nick Clemens <nick@bywatersolutions.com> a écrit :
Hi All,
We have had several requests recently for an easy way to access current/last year's circulation stats for items, without having to create reports totalling these numbers. The numbers here are used for weeding, state reporting, etc.
Other systems have fields: 'Year to date circ' and 'last year circ'
We have discussed several possible developments: - a new table to track these - adding a new field, or altering 'issues' to use JSON and storing circ/renewal counts by year - adding two new fields to the items table and use a cronjob to move 'current year' circ to 'last years circ' at the end of the year.
We wanted to check in with the community to see if this is a request that others have or have seen, and how they handle these.
Thanks for any info. Nick (kidclamp)
-- Nick Clemens ByWater Solutions bywatersolutions.com Phone: (888) 900-8944 Pronouns: (he/him/his) Timezone: Eastern Follow us: <https://www.facebook.com/ByWaterSolutions/> <https://www.instagram.com/bywatersolutions/> <https://www.youtube.com/user/bywatersolutions> <https://twitter.com/ByWaterSolution> _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Alvaro Cornejo -
Nick Clemens