Monthly Circulation Statistical Reports

Submission Notes: This report was submitted on 5/19/10 by Amy Terlaga of Bibliomation, Inc. It was originally created by Dan Scott of Laurentian University.

Version: Evergreen v.1.6.0.2

Data Sources Used:

Running Tips/Guidelines: This report is designed to be run the day/month AFTER the month you are interested in getting monthly circulation totals. If you would like it to reflect this month's activity, remove - '1 month'::interval If you would like it to reflect activity from two months ago, change the 1 to a 2 (and so on). Where you see ORG, replace with your org unit's short name.

SELECT aou.name AS "Library", asceum.stat_cat_entry AS "Borrower Stat", COUNT(acirc.id) AS "COUNT"
  FROM action.circulation acirc
  JOIN actor.org_unit aou ON acirc.circ_lib = aou.id
  LEFT OUTER JOIN actor.stat_cat_entry_usr_map asceum ON asceum.target_usr = acirc.usr
  LEFT OUTER JOIN actor.stat_cat astat ON asceum.stat_cat = astat.id
  WHERE aou.shortname = **'ORG'**::text AND date_trunc('MONTH'::text, acirc.create_time) = date_trunc('MONTH'::text, now() - '1 mon'::INTERVAL)
  GROUP BY aou.name, asceum.stat_cat_entry
 
UNION
 
SELECT 'ZZZ Total' AS "Library", '' AS "Borrower Stat", COUNT(acirc.id) AS "COUNT"
  FROM action.circulation acirc
  JOIN actor.org_unit aou ON acirc.circ_lib = aou.id
  LEFT OUTER JOIN actor.stat_cat_entry_usr_map asceum ON asceum.target_usr = acirc.usr
  LEFT OUTER JOIN actor.stat_cat astat ON asceum.stat_cat = astat.id
  WHERE aou.shortname = **'ORG'**::text 
  AND date_trunc('MONTH'::text, acirc.create_time) = date_trunc('MONTH'::text, now() - '1 mon'::INTERVAL)
 
ORDER BY 1, 2, 3;

Back to Evergreen Circulation Reports page