Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About the Data

Please note that the dashboards and Excel file downloads linked under the "Tableau Dashboard" and "Excel File Download" columns below The following reports are automatically updated every morning by 10:00am. The reports include data that shown was current in the FOLIO system at the end of the previous business day (yesterday's data).

All Cornell Library staff who have approval to access to the Library Data Platform (LDP) reporting database have access to view these data dashboards.  If you have questions about this data, please submit a request through the Requesting Reporting Help form.

Documentation

Accessing and Using Data Dashboards - Detailed Instructions

...

...

Access Services Dashboards & Excel Downloads


Index NumberNameDescriptionTableau Dashboard
or
Excel File Download
Description
DocumentationSQL Query Code
TD400Physical Items Circulation Counts
Dashboard 
Provides fiscal year counts of physical collections use (loans and renewals) with filters for owning library, patron group, material type, and collection type (regular, equipment, etc.). Also provides counts of patron filled requests.
N/A
Physical Items Circulation Counts Dashboard 

ADC CR184A loans and renewals Excel download

ADC CR193 filled delivery requests Excel download

Filtering data to obtain specific counts

CR184A SQL Query

CR193 SQL Query

TD401Circulation Desk
Transaction Dashboard
TransactionsProvides counts of circulation desk transactions by month, day, date, and time of day, with filters for material type, request type, and action type (checkin or checkout). Circulation Desk Transaction Dashboard

N/A
TD402Missing and In Transit Items
Dashboard
Provides a list of all items that have an item status of 'missing', including item details, with filters including Library, permanent location, missing status date, call number and LC class. Also contains a separate view for list of items where item status is 'in transit', along with  item details and a filter for number of days in transit. If items haven't been checked in at the home location (permanent location) after a specified time period, the items might have been lost or misplaced on their way back to their home location.Missing and In Transit Items Dashboard

N/A
CR204Missing, Lost, Claimed, Returned
Excel Download
ItemsThis query creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination. Sorts in call number order. To view results for a particular library, sort your Excel file on the library_name column. To view results for a particular item status (e.g., Missing, Aged to Lost, Lost and Paid), sort your Excel file on the status_name column. Missing Lost Claimed Returned Excel Download

CR204