[Koha-bugs] [Bug 7679] Statistics wizard: circulation (new filters)

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

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

--- Comment #14 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
Hi
Nice enh
Tested on sandbox 1

* Test of Sort by hours: seems OK

Period From 03/09/2013
Period To 04/09/2013
Library = MAURES
Home branch = MAURES
Holding branch = MAURES
Event = issue
Display by = 4 
datetime / itemtype         Compact Disque     Livre audio     Livre     Revue 
       TOTAL
9     0     0     0     1     0     0     1
10     0     0     0     2     0     0     2
11     0     0     0     3     0     0     3

In database : 
2013-09-03 09:45:23    MAURES        0.0000    issue            5464    LIVR   
6068        
2013-09-03 10:57:34    MAURES        0.0000    issue            4862    LIVR   
7570        
2013-09-03 10:57:44    MAURES        0.0000    issue            1338    LIVR   
7570        
2013-09-03 11:19:39    MAURES        0.0000    issue            5663    LIVR   
3488        
2013-09-03 11:29:47    MAURES        0.0000    issue            2171    LIVR   
3431        
2013-09-03 11:39:31    MAURES        0.0000    issue            4350    LIVR   
5212        

* test of flter by itemtype : seems ok (same kind of test)

* test of patron attribute filter : 
- display all checkouts between  01/08/2013 and 04/09/2013 ; dates in columns ;
professions in rows
=> I did not check database, but presentation of results seemed ok :
agent administratif     0     0     0     0     0     0     0     0     0     0
    0
agent d'accueil     0     0     0     0     0     0     0     0     0     0    
0
enfant     0     0     1     0     0     0     0     0     0     0     1
Enseignant     0     0     1     0     0     0     0     0     0     0     1
etc.

- use a value of attribute Profession as a filter : value "Enseignant"
display only one line => ok

PROFESSION / datetime     9     10     11     12     13     14     15     16   
 17     18     TOTAL
Enseignant     0     0     1     0     0     0     0     0     0     0     1
TOTAL     0     0     1     0     0     0     0     0     0     0     3

============
But, at that point, I remarked a bug : 
TOTAL is wrong : the last column is displaying "3", while the last column for
the only row ('Enseignant') is 1.
So, for Koha, the "sum" of 1 is 3. Wrong somewhere

Other remarks (cosmetic)

I think "Item type" should be better understood if named "Document type". That
make obvious that is using biblioitems.itemtype (I suppose so?) and not
items.itype.
In the results, the " Display by = [1...4] " line is not easy to understand. It
seems that each number match a kind of date grouping (hours, months...). Could
you display it in plain english?

Could you check the calculation of "TOTAL" line?

M. Saby

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