Filtering Data to Obtain Specific Counts

CIRCULATION CHARGES AND RENEWALS

Filter to:
•    Pick fiscal year wanted
•    Exclude “SPEC (Library Dept Card)” from patron_group_name
•    Exclude “BD*” and “ILL*” from collection_type

Note: FOLIO figures exclude any manual charges reported. Contact A&P.

LIBRARY TO LIBRAY DELIVERY

Filter to:
•    Pick fiscal year wanted
•    Select only “Page” from request_type
•    Exclude “SPEC (Library Dept Card)” from patron_group_name

CONTACTLESS PICKUP

Filter to:
•    Pick fiscal year wanted
•    Select only “Contactless pickup” from pickup_type
•    Exclude “SPEC (Library Dept Card)” from patron_group_name