Lists titles with 2 or more holds, and includes bib format, bib call number, active holds count, and count of holdable copies.

Submitted by Lindsay Stratton, Westchester Library System.

Hold/Item Ratio per Bib

Name = Title

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Simple Record Extracts -> Title Proper (normalized)
• Transform = Raw Data

Name = Author

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Simple Record Extracts -> Author (normalized)
• Transform = Raw Data

Name = Record ID

• Field Path = Hold/Copy Ratio per Bib -> Record ID
• Transform = Raw Data

Name = ISBN

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Simple Record Extracts -> ISBN
• Transform = Raw Data

Name = Bib Format

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] MVF Attributes -> Value
• Transform = Maximum Value

Name = Bib Call Number

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Flattened MARC Fields -> Normalized Value
• Transform = First Value

Name Active Holds

• Field Path = Hold/Copy Ratio per Bib -> Active Holds
• Transform = Raw Data

Name = Holdable Copy Count

• Field Path = Hold/Copy Ratio per Bib -> Holdable Copy Count
• Transform = Raw Data

Name = Active Holds

• Field Path = Hold/Copy Ratio per Bib -> Active Holds
• Transform = Raw Data
• Operator = Greater Than or Equal To
• Filter Value = 2

Name = Attribute

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] MVF Attributes -> Attribute
• Transform = Raw Data
• Operator = Equals
• Filter Value = search_format

Name = Tag

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Flattened MARC Fields -> Tag
• Transform = Raw Data
• Operator = Equals
• Filter Value = 082

Name = Subfield

• Field Path = Hold/Copy Ratio per Bib -> [Left Required] Record ID -> [Left Required] Flattened MARC Fields -> Subfield
• Transform = Raw Data
• Operator = Equals
• Filter Value = a