openlibraryenvironment / reshare-analytics

Community query repository for ReShare analytics based on Metadb/LDP
Apache License 2.0
3 stars 2 forks source link

Total reqs # in core supplying report appears to be greater than sum of requests filled, shipped, cancelled or unfilled in given date range #44

Closed debradenault closed 2 years ago

debradenault commented 2 years ago

@scwiek

Mansfield Core Supplying 3/1/22 - 4/1/22

  | reqs | unfilled | filled | shipped | cancels | filled_ratio | supplied_ratio Mansfield University | 147 | 8 | 42 | 42 | 0 | 0.29 | 0.29

As of 4/3, Mansfield's Supply app shows 49 requests dated 3/1/2022 or after, which pretty much corresponds to the unfilled + filled counts shown in the report. I have a feeling that the other 100+ odd in the total count are requests that were shipped (and counted as filled/shipped) in a previous month but are still active, that is, have not been returned and completed but not sure.

What accounts for these other odd 100 requests or do we need to adjust that count?