[Koha] Adding recent (current/past year) statistics to the items table

[Alvaro Cornejo]

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