en:documentation:borrowers_stats.pl [Koha Developer Wiki]

<h1>Borrowers stats help</h1> <p>This page is to be used as a wizard to compose two entries table stats on borrowers.</p> <p>You must bear in mind what the table will look like :</p> <p> <table>

<tr> <td> row/colunm </td> <td> column criteria1 </td> <td> column criteria2 </td> <td> total rows</td> </tr>
<tr> <td> row criteria1</td> <td> count11 </td> <td> count12 </td> <td>total row1 </td> </tr>
<tr> <td> row criteria2</td> <td> count21 </td> <td> count22 </td> <td>total row2 </td> </tr>
<tr> <td> Total cols</td> <td> total col1</td> <td> total col2</td> <td> Global total</td> </tr>
</table></p>

<p> For instance, if you choose to check row for Borrower Category Column for Branches, you will be displayed a table containing the different borrowers categorycodes on rows, and different branchcodes on columns as such : </p><p> <table>

<tr> <td> catcode/branchcode </td> <td> BranchA</td> <td> BranchB</td> <td> total </td> </tr>
<tr> <td> A</td> <td> 12 </td> <td> 22 </td> <td>34</td> </tr>
<tr> <td> C</td> <td> 11</td> <td> 12 </td> <td>23</td> </tr>
<tr> <td> I</td> <td> 21</td> <td> 22</td> <td>43</td> </tr>
<tr> <td> Total </td> <td> 44</td> <td> 56</td> <td> 100</td> </tr>
</table>

</p><p> You can choose to display the results on screen or get them in your office suite (would it be gnucalc, oocalc, or another calc) with the radio button display. You can change the set of the file generated changing Export in the textarea. </p> <p> <h2> Criteria on row/column</h2> <ul> <li>You can choose sort1 sort2 if filled.</li> <li>You can choose Branch, zipcode or categorycode.</li> <li>If you chose zipcode, since the 2 first digits in France represents the country (Hérault 34, Haute-Garonne 31), some may want to have stats on representation of this countries. That is why you can select to group stats on some digits of zipcode.</li> </ul> </p> <p> <h2> Filters </h2> <ul> <li>You can filter on sort1 sort2 if filled.</li> <li>You can filter on zipcode, branch or categorycode.</li> <li>Branches and categorycodes are chosen in a select list.</li> <li>Zipcode can use special characters like * for many characters. say 31* to get french people that live in Haute-Garonne</li> </ul> </p>