dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #01151
Re: Missing values in calculating indicators
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<mailto: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<mailto: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.
Follow ups
References