Data quality checks

Support - Assistance technique
1

I’ve established a data quality check where the sum of a data element’s categories cannot be less than another data element. However the check treats missing values as NULLs rather than 0s so the check passes when it should not. Is there any way to get the check to treat missing cells as 0s?

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.

2

Hi Tom,

there has been a debate around this. In many situations you want to ignore the validation if you have missing values (HIV+ tests <= HIV tests) and in some situations not (Total deliveries >= normal + breach + cs). So we have decided to implement an option for this for the validation process for the next version (2.9).

https://blueprints.launchpad.net/dhis2/+spec/validation-rules-null-operands

regards, Lars

···

On Fri, May 25, 2012 at 8:45 AM, hiattt@wpro.who.int wrote:

I’ve established a data quality check where the sum of a data element’s categories cannot be less than another data element. However the check treats missing values as NULLs rather than 0s so the check passes when it should not. Is there any way to get the check to treat missing cells as 0s?

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

3

Thanks, Lars. I added one comment in the discussion thread on how it might be implemented. If I should have noted this in a different spot (whiteboard?) let me know.

Tom

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: 25 May 2012 15:26

To: Hiatt, Mr Tom (WPRO); dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Data quality checks

Hi Tom,

there has been a debate around this. In many situations you want to ignore the validation if you have missing values (HIV+ tests <= HIV tests) and in some situations not (Total deliveries >= normal + breach + cs). So we have decided to implement an option for this for the validation process for the next version (2.9).

https://blueprints.launchpad.net/dhis2/+spec/validation-rules-null-operands

regards, Lars

On Fri, May 25, 2012 at 8:45 AM, hiattt@wpro.who.int wrote:

I’ve established a data quality check where the sum of a data element’s categories cannot be less than another data element. However the check treats missing values as NULLs rather than 0s so the check passes when it should not. Is there any way to get the check to treat missing cells as 0s?

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@lists.launchpad.net

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.