Either cost returned for the package OR total of all selected titles in package costs fiscal year
Summary table
Total Usage
total usage across all selected titles in package for the selected fiscal year - ideally usage only represents the platforms tied to the package
Summary table
Cost per use
Package cost divided by Total Usage for the selected fiscal year
Title list
Usage
total usage for title in package for the fiscal year (unsure if response supports a total) - ideally usage only represents the platforms tied to the package
Title list
Cost per use
Title cost divided by Title Usage for the selected fiscal year
Title list
% of usage
percentage of usage for the title in the package across all selected titles in a package usage for the selected fiscal year
Title+Package record - calculations
Location
Field
Calculation
Summary table
Usage
total usage across the title in the package for the selected fiscal year - ideally usage only represents the platforms tied to the package
Summary table
Cost per use
Title cost divided by Usage for the selected fiscal year
Requests table
Total usage per platform
total usage for title in package for the selected fiscal year for a platform
Requests table
Total usage across all platforms
Sum of usage across all platforms
Title record - calculations
Location
Field
Calculation
Summary table
Cost across publisher platforms
Total title costs across all publisher platforms for the selected fiscal year
Summary table
Cost across non-publisher platforms
Total title costs across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Cost across all platforms
Total title costs across all platforms for the selected fiscal year
Summary table
Usage across publisher platforms
Total title usage across all publisher platforms for the selected fiscal year
Summary table
Usage across non-publisher platforms
Total title usage across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Usage across all platforms
Total title usage across all platforms for the selected fiscal year
Summary table
Cost per use publisher platforms
Total Title cost divided by Total Usage across all publisher platforms for the selected fiscal year
Summary table
Cost per use non-publisher platforms
Total Title cost divided by Total Usage across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Cost per use non-publisher platforms
Sum of Total Title costs divided by Sum of Total Usage across all platforms for the selected fiscal year
Requests table
Total usage per platform
total usage for title per platform for selected fiscal year
Requests table
Total usage across all publisher platform for month
total monthly usage for title across all publisher platforms for selected fiscal year
Requests table
Total usage across all publisher platform
total usage for title across all publisher platforms for selected fiscal year
Requests table
Total usage across all non-publisher platform for month
total monthly usage for title across all non-publisher platforms for selected fiscal year
Requests table
Total usage across all non-publisher platform
total usage for title across all non-publisher platforms for selected fiscal year
Requests table
Total usage across all platforms for month
Sum of usage across all platforms for month for the selected fiscal year
Requests table
Total usage across all platforms
Sum of usage across all platforms for the selected fiscal year
Objectives
Cost per use apis may return cost per use value but our development team may need to calculate this value rather than rely on the API response.
Investigate
how data returned from Cost-Per-Use service can be used for displaying information in mod-kb-ebsco-java
Evaluate below tables for calculations needed to support mockups
Package record: https://drive.google.com/file/d/1oWvhXBeE58KEoxkiaWYsBsKI6LqK8oaB/view?usp=sharing
Package - title record: https://drive.google.com/file/d/1ttgxYvr7bzRYf47DaGU4vgWn0EkbwZ1f/view?usp=sharing
Title record: https://drive.google.com/file/d/1ttgxYvr7bzRYf47DaGU4vgWn0EkbwZ1f/view?usp=sharing
Documentation
Cost Per Use Swagger Documentation
Already asked questions
Spike Outcome
Document formulas to support calculations
Documentation will be available on confluence
Package record - calculations
Location
Field
Calculation
Summary table
Package cost
Either cost returned for the package OR total of all selected titles in package costs fiscal year
Summary table
Total Usage
total usage across all selected titles in package for the selected fiscal year - ideally usage only represents the platforms tied to the package
Summary table
Cost per use
Package cost divided by Total Usage for the selected fiscal year
Title list
Usage
total usage for title in package for the fiscal year (unsure if response supports a total) - ideally usage only represents the platforms tied to the package
Title list
Cost per use
Title cost divided by Title Usage for the selected fiscal year
Title list
% of usage
percentage of usage for the title in the package across all selected titles in a package usage for the selected fiscal year
Title+Package record - calculations
Location
Field
Calculation
Summary table
Usage
total usage across the title in the package for the selected fiscal year - ideally usage only represents the platforms tied to the package
Summary table
Cost per use
Title cost divided by Usage for the selected fiscal year
Requests table
Total usage per platform
total usage for title in package for the selected fiscal year for a platform
Requests table
Total usage across all platforms
Sum of usage across all platforms
Title record - calculations
Location
Field
Calculation
Summary table
Cost across publisher platforms
Total title costs across all publisher platforms for the selected fiscal year
Summary table
Cost across non-publisher platforms
Total title costs across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Cost across all platforms
Total title costs across all platforms for the selected fiscal year
Summary table
Usage across publisher platforms
Total title usage across all publisher platforms for the selected fiscal year
Summary table
Usage across non-publisher platforms
Total title usage across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Usage across all platforms
Total title usage across all platforms for the selected fiscal year
Summary table
Cost per use publisher platforms
Total Title cost divided by Total Usage across all publisher platforms for the selected fiscal year
Summary table
Cost per use non-publisher platforms
Total Title cost divided by Total Usage across all non-publisher platforms for the selected fiscal year
Summary table
Sum of Total Cost per use non-publisher platforms
Sum of Total Title costs divided by Sum of Total Usage across all platforms for the selected fiscal year
Requests table
Total usage per platform
total usage for title per platform for selected fiscal year
Requests table
Total usage across all publisher platform for month
total monthly usage for title across all publisher platforms for selected fiscal year
Requests table
Total usage across all publisher platform
total usage for title across all publisher platforms for selected fiscal year
Requests table
Total usage across all non-publisher platform for month
total monthly usage for title across all non-publisher platforms for selected fiscal year
Requests table
Total usage across all non-publisher platform
total usage for title across all non-publisher platforms for selected fiscal year
Requests table
Total usage across all platforms for month
Sum of usage across all platforms for month for the selected fiscal year
Requests table
Total usage across all platforms
Sum of usage across all platforms for the selected fiscal year