Hi Christopher, It depends on how your report is written, you want to be sure to be pulling numbers from both the deleted* database tables as well as the current (existing item) ones. This generally involves doing a UNION between the items and deleteditems tables, for instance. There are lots of great examples on how to accomplish this in the reports library, e.g. see this one: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Circulation_by_... Hope that helps! Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null On Thu, Jan 26, 2017 at 2:55 PM, Christopher Davis <cgdavis@uintah.utah.gov> wrote:
Dear Colleagues,
Will someone please remind me if the circulation statistics of an item are included in something like a year-end report if the item was deleted from Koha before the report was run. My institution's circulation numbers are down this year and we're attempting to discover why.
TIA,
Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgdavis@uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary instagram.com/uintahcountylibrary _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha