dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

My feeling is that if there are no values registered (in datavalue table)
then there should be none in data mart either, simply leave it blank/NULL.
This '0' in datamart seems misleading when we know there are no values
entered. I think Jason requested the same (in another mail on this list a
few weeks back) based on his experience in Zambia.

best regards,
Ola Hodne Titlestad
HISP
University of Oslo


On Tue, May 19, 2009 at 5:29 PM, <johansa@xxxxxxxxxx> wrote:

> Another issue from Sierra Leone:
>
> When looking at indicators in pivot tables, even those orgunit/period
> combinations with missing numerator is displayed (as 0%). The problem is
> that these disturb the totals, as we at the current stage of
> incompleteness of data submission would like to estimate the values based
> on the data we actually have, not counting those months missing. Let me
> illustrate with an example:
>
> For four months, the raw data for a facility would be
> 4, ,5,5
>
> So one month missing. The output numxfactor from the data mart export for
> this percentage indicator would be 400, 0, 500, 500, though the missing
> month is most probably NOT zero. We would like it to be excluded from the
> data mart export (as is done with raw data export), since unticking
> orgunits month by month in the pivot table is a rather long and tedious
> process.
>
> I think this is done in the data mart export where the numerator is
> factored with the indicator type factor, always returning an integer.
> Something like "null"x100=0, while in this case it makes sense to return a
> "null" (which leads to not exporting the denominator too). However, this
> must be an option, since many countries do not enter zeros but leave those
> fields blank. Any thoughts on this?
>
> Johan
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>