** Changed in: dhis2
Milestone: 2.0.4 => 2.0.5
--
ReportTable: DataElement dimension tables do not work correctly
https://bugs.launchpad.net/bugs/490393
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
Status in DHIS 2 - District Health Information Software: Confirmed
Bug description:
I have tested the new type of report table called Data Element Dimension table
in Reports->Report Tables and have discovered a few issues:
* The viewing of subtotals and totals in html, excel, and csv has not been
implemented although the actual table generated in the database has these. Not
sure whether this was an intentional shortcut for the 2.0.3 release or not.
* When there is only one dimension (category) the subtotals are still shown in
the table which means that all numbers are simply repeated for every option in
that category since these subtotals are then the same as the raw values. So
when only one category is used there should be no subtotals, just the total.
* The naming of the columns for the optioncombos is confusing since it seems
random which category that comes first in the name. E.g a age+gender table can
look like this. "Male <5y", "Female <5y", ">5 Male", ">5 Female" which is
really difficult to work with. I know data entry deals with this issue and
seems to solve it, even with custom sorting, why don't we use the same approach
here?
* The selected DimensionOption should be persisted on edit.
* There seems to be some problems with the calculation of subtotals:
Example 1) The following report table is based on the Sierra Leone database,
you can see the in SQL here (http://pastebin.com/m30143e7c) that one of the two
dimensions (fixed/outreach) do not have any values for its subtotals (total
fixed and total outreach) as the values are simply '0' although the raw values
in the same table clearly show that there are values reported for these
dimensions. The other dimension (less than 12 months, 12-59 months) works as
expected for the subtotals and the total is also fine.
Example 2) This table (http://pastebin.com/m61beb2d8) is based on a category
combo consisting of the two categories (and their options) "preg&nonpreg
15-49y" (preg 15-49y, nonpreg 15-49y) and "fixed/outreach" (fixed, outreach),
so totally 4 raw values, 4 subtotals, and 1 total are displayed in the report
table.
This one turned out to be a bit more correct than example 1) as it has got all
its 4 subtotals populated, but only 3 of them are correct. The subtotals for
column total_1549_yrs_nonpreg has wrong values systematically for all the data
elements (rows). It is clear that only one of the two raw values that includes
this dimension option are used. You can see that the subtotal equals the value
of the _1549_yrs_nonpreg_fixed column and for some reason excludes the other
raw value in the _1549_yrs_nonpreg_outreach column.
Example 3)
This table (http://pastebin.com/m410454f3) for morbidity age group + gender
shows some other aggregation problems for subtotals. Haven't spent that much
time looking at all its problems, but quickly notices that the two subtotals
'Total Male' and 'Total 15-24y' are both '0' for all the rows while e.g the raw
values for the combination 'Male 15-24 y' has values for most of the rows.
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
