← Back to team overview

dhis2-users team mailing list archive

Re: Missing values in calculating indicators

 

Hi Tom,

regarding indicators we do produce the aggregated value if the numerator is
not existing or zero by default. The reason is that we often connect with
3rd party tools like Excel which will do their own aggregation based on
data e.g. on the lowest level.

If you prefer to omit indicators with zero numerators you can go to system
settings and set the "Omit indicator values with zero numerator value in
data mart" setting to true.

We of course ignore indicators where the denominator is not existing/zero
as it would be illegal to calculate.

Lars


On Thu, May 31, 2012 at 8:13 AM, <hiattt@xxxxxxxxxxxx> wrote:

>  I see that when indicators are calculated, records where either the
> numerator or denominator is missing are not excluded. For me this would be
> ideal default behavior so that the indicator isn’t thrown wildly off by
> assuming no reporting is the same as reporting 0. I could imagine some
> times when one would want an unreported numerator to be treated as 0 (if
> it’s likely that it isn’t reported, because it doesn’t exist), so maybe an
> option to override default in the indicator definition screen would be
> good. I can’t think of a scenario where one would want missing denominators
> to be treated as 0.****
>
> ** **
>
> I don’t know if others are running into this, or if it’s only me. If there
> is a way to set this already let me know.****
>
> ** **
>
> Thanks,****
>
> Tom****
>
> ** **
>
>
>
>
>
>  ------------------------------
>
> This message was scanned for viruses with Trend Micro ScanMail, GFI
> MailSecurity and GFI MailEssentials by the World Health Organization
> Regional Office for the Western Pacific. However, the recipient is advised
> to scan this e-mail and any attached files for viruses.
>
> Disclaimer:
>
> This e-mail, together with any attachments, is intended for the named
> recipients only and is confidential. It may also be privileged or otherwise
> protected by law.
>
> If you have received it in error, please notify the sender immediately by
> reply e-mail and delete it and any attachments from your system. You may
> not copy or disclose its contents to anyone.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References