dhis2-users team mailing list archive

[<hiattt@xxxxxxxxxxxx>]

Hi Jason,

Sorry I'm in the dark on some of these debates. Please let me know if I'm getting annoying on any of my questions!

My problem is slightly different. It's more like this example for a specific period:

Org unit             Numerator         Denominator
O1                    50                     100
O2                    40                     50
O3                    80                     NA

For indicator X = (numerator / denominator) * 100

What I would like to see is (50 + 40) / (100 + 50) = 60%

What I'm seeing is (50 + 40 + 80) / (100 + 50) = 113%

Does that make sense? Again I could see a debate on whether to include rows with missing numerator data, but I can't think of a scenario where you would want rows with missing denominator data.

Thanks again, and please do let me know if I'm abusing the mailing list. You all have been so responsive and I appreciate it, but I don't want to wear out my welcome!

Tom


________________________________
From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
Sent: 31 May 2012 14:39
To: Hiatt, Mr Tom (WPRO)
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Missing values in calculating indicators

Hi Tom,

You can consult the DHIS2 mailing list archives for long and torturous email threads on this issue and it has come up many times.

What would the desired behavior be in your case? Do you mean, that something like

NA + 1 + 2 +3 = NA

This is not the default behavior at all in DHIS2, and most of the time NAs/NULLS will be coerced to zero. So, the default behavior in DHIS2 is

NA + 1 + 2+ 3  = 6

In cases when the NAs are important, we have always had to resort to SQL/R/Stata to perform the aggregation. But maybe there is a better solution from someone else?

Best regards,
Jason




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.