| Table of Contents |
|---|
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.
...
- Use the filter for the appropriate field, such as MMS ID or Item ID. If you are expecting an exact match, select "is equal to" and paste in your string of IDs
- If you are not expecting an exact match (e.g., if the identifier is an ISBN and the field probably contains multiple ISBNs) select "contains any"
- There is some limit to how many IDs you can paste into a filter. The limit is much higher if it is an exact match. I usually do four pages of ISBNs at a time and up to 26 pages of Item or MMS IDs. Analytics is sometimes inconsistent about how much it will accept, so if you get an error, trying using fewer IDs temporarily.
- When copying IDs from the Word document, make sure your string does not start or end with a semicolon!
Strategies for Identifying Malformed Barcodes
- Character length
- Duplicate the barcode column
- Edit the formula to
CHAR_LENGTH("Physical Item Details"."Barcode") - In Filters, filter on
CHAR_LENGTH(Barcode) is not equal to / is not in 14 - Contains non-numeric characters
- Duplicate the barcode column
- Edit the formula to
evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode") - In Filters, filter on
EVALUATE('REGEXP_INSTR(%1, ''^[... is equal to / is in 0 - Barcodes that do not start with 39074 (this applies to Main campus; Ginsburg barcodes may start with 32875; other campuses may have other expected barcode prefixes)
- Duplicate the barcode column
- Edit the formula to
SUBSTRING("Physical Item Details"."Barcode" FROM 0 FOR 5) - In Filters, filter on
SUBSTRING(Barcode FROM 0 FOR 5) is not equal to / is not in 39074