← Back to team overview

dhis2-users team mailing list archive

Re: Missing values in calculating indicators

 

Okay I understand. I think supporting your requirement would def make
sense. I am only worried this will incur a huge performance penalty to the
aggregation process.
On May 31, 2012 9:51 AM, <hiattt@xxxxxxxxxxxx> wrote:

> **
>
> Thanks, Lars. Sorry for the ambiguity in my original question. I would
> still like to have the indicator calculated for each time period, I would
> just like it to omit from the calculation org units that didn’t report the
> numerator. ****
>
> ** **
>
> Thanks, for pointing out that setting. That’s also very useful.****
>
> ** **
>
> Tom****
>
> ** **
>  ------------------------------
>
> *From:* Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
> *Sent:* 31 May 2012 15:24
> *To:* **Hiatt, Mr Tom** (WPRO)
> *Cc:* **dhis2-users@xxxxxxxxxxxxxxxxxxx**
> *Subject:* Re: [Dhis2-users] 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****
>
> ** **
>
>
>
>
>
>  ------------------------------
> 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.
>

References