← Back to team overview

dhis2-devs team mailing list archive

Re: exclude indicator export where numerator is missing


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
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

Follow ups