Alma Analytics – Discovering why the usage may have decimal points in the cost per use
This relates to the Cost Per Use in Alma Analytics E-Inventory subject area.
Default reports and dashboard in folder “/shared/Alma/Cost per use via COUNTER reports e-inventory and acquisitions data”
There are cases where the usage may appear as decimal values. This depends on how the report is made, and reflects a proportion of the usage based on price.
Here we will look at an example to see how and why this happens.
In the sample below we that title “Hypatia : a journal of feminist philosophy.” has a JR1 usage of 322 for FY-2018 and costs a total of 459.49 for that fiscal year:
This journal, is in three different electronic collections:
- JSTOR Arts and Sciences V
- Project Muse Standard Collection
- Wiley Online Library Database Model 2017
Here in the repository search we can see the three different electronic collections:
Now if we add the Electronic Collection Public Name (and optionally the portfolio ID) to the analytics report we see that for “JSTOR Arts and Sciences V” the usage is 14.20, and for “Project Muse Standard Collection” the usage is 38.65 and for “Wiley Online Library Database Model 2017” it is 269.14. So the total usage is still 322.00, but it is split into three collections. (By the way the usage below adds up to 321.99 and not 320 because we are displaying only two decimal places which are rounded)
Why was it split? And how was split into these numbers? The usage is proportionally split according to the price of the resource in each electronic collection. Let’s add the cost and see. The prices for the portfolio in electronic collection “Wiley Online Library Database Model 2017” is much more than the price for the other two collections. It has the highest cost and thus when dividing the usage it has the highest usage. The total cost, as we saw above, is 459.49, but it is not 1/3 of that price in each collection.
We can see the exact percentage of the total cost for each electronic collection if we add the analytics field “percent MMS Cost”
- The resource in electronic collection “JSTOR Arts and Sciences V” has a price which is 4.4 % of the total price. It therefore has usage which is “14.20” which is 4.4 % of the total usage of 322.
- The resource in electronic collection “Project Muse Standard Collection” has a price which is 12 % of the total price. It therefore has usage which is “38.65” which is 12 % of the total usage of 322.
- The resource in electronic collection “Wiley Online Library Database Model 2017” has a price which is 83.6 % of the total price. It therefore has usage which is “269.14” which is 83.6 % of the total usage of 322.
Note: All numbers below are not exact to the decimal because we are displaying two decimal places. if we display more we get more of an exact number, but for our purposes two decimal places suffices.