Cataloging/Collection Statistics
- In the cataloging mode, choose Statistics
- Create a query and name your "results file"
- Web management reports retain data for 3 years back; info from a transaction file 105419; new spreadsheet interface = http://www.consuls.org/iii/webrpt; opens immediately in Excel;
- Cataloging session statistics: from reports in the menu bar, cumulative statistics by individual
- Acquisitions statistics: fund activity reports, vendor reports
- Millennium Statistics mode: authorization #19 for create statistical reports; based mostly on fixed field data; info based on date fields (including cat dates!); how many records in the database!!; project costs for future purchases; counts of records in call number ranges - works with SCAT table (ranges of call numbers to collect data on); can also look at payment fields (non-fixed); cross tabulation of one fixed field against another
- Create lists and statistics work together; stats can report on attached records as well as bib records in a review file
- good data and bad data; records have to be coded properly; can use some fixed field codes for different purposes
- 1,000 saved queries, 500 results files
- Steps:
- New Query: query editor, name the results file minimally
- Range (bib records or others, change the starting letter, INCLUDING O), review file, Index (i.e. author, call number, etc - NO WILDCARDS), advanced (keyword search, using boolean operators)
- Query type: field statistics - all fixed fields in type of record specified; fastest accumulation - always turn on (will not pause to refresh the screen); split multi - for fields that can more than one code (ie. bib location, or order record fund codes) will count each record ONCE for each LOCATION; results is simply COUNTS of each fixed field for all bib records
- "limit by time range" only available with ORDER records
- Query type: field statistics, order records: can compare two years; tabs at top can show budget planning numbers, and review collection development
- Query type: Periodic Report - limit query to records in the database that match the date range you are looking for; items added last year by month;
- Query type: cross tab - select 2 different fixed field for x and y axes;
- User licenses for Mill stats - reports use a license