[Koha-bugs] [Bug 15422] New: Number of items to order on holds ratio report will not fulfill the holds ratio.

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15422

            Bug ID: 15422
           Summary: Number of items to order on holds ratio report will
                    not fulfill the holds ratio.
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: gmcharlt at gmail.com
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

When running the holds ratio report ( circ/reserveratios.pl ), I have the hold
ratio set to 3 (this is the threshold ratio, set in the Refine results box on
the right).

This is from the first row on the page:

Holds       : 40
Items       : 3
Hold Ratio  : 13.33
...
Items needed: 4 to order

If we add the recommended 4 items, we have 40 holds and 7 items, which brings
the hold ratio to 5.7, which is still above the threshold ratio of 3.

In order to bring the actual hold ratio below the threshold ratio of 3,

I would need

40 / ( 3 + x ) = 3
40             = 9 + 3x
31             = 3x
10.3           = x

Or, more generally

$data->{reservecount} / ( $data->{itemcount} + $needed ) = $ratio
$data->{reservecount} / $ratio                           = $data->{itemcount} +
$needed
$needed = ( $data->{reservecount} / $ratio ) - $data->{itemcount}

Instead at circ/reserveratios.pl line 158, we have

  ratiocalc => sprintf( "%.0d", $ratio_atleast1 ? ( $thisratio / $ratio ) :
$thisratio ),

which translates to

  $needed = ( $data->{reservecount} / $data->{itemcount} ) / $ratio

This means that if the library orders the recommended number of copies, the
title will show up again on the holds ratio report, assuming that the number of
holds stays more or less constant.

-- 
You are receiving this mail because:
You are watching all bug changes.