Miscellaneous Analytics Details

Loan Count

If you want to include the total number of loans for an item in your Analytics report, you need to use a Physical Items report rather than a Fulfillment report. In the Physical Items report, go to Physical Item Details, then No of Loans. If you use a Fulfillment report, there is a measure called Loans that is actually year-to-date loans, not total.

Exporting MMS IDs

When you export a report to a csv file and open it in Excel, MMS IDs and Item IDs will get rounded, resulting in a number that ends in 000 rather than our institutional identifier of 811. To get around this,

1. Export the data to csv, but do not open the file.
2. Change the extension on the file to .txt.
3. Open Excel.
4. Go to File > Open, and find the .txt file. Excel will automatically start the Import Wizard.
5. Select Delimited, click Next.
6. Select Comma as the delimiter. Click Next.
7. Highlight the column that has the ID in it. In the top left corner of the wizard, select Text as the data format.
8. Click Finish.