← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] WHO DQA tool and Zeros not storing in DHIS2


Dear Jason,
Thanks for the confirmation. Based on our discussions few minutes ago; the
M&Es think this will help them to show the performances of their programs.
For example:
In a particular facility A; during the months Jan, Feb, Mar, Apr, May; the
cases of measles are 5, 8, 9, 0, 10...
In our data collection, Apr will be seeing as no entry ( which means we
can’t identify whether it is zero measle case or no entry was done.

On Thu, 22 Nov 2018 at 10:34, Jason Pickering <jason.p.pickering@xxxxxxxxx>

> Hi Gerald,
> No, they will not appear unless people re-enter the data. When this
> setting is used, what happens on the client side, is that even if people
> enter a zero, it will never get transmitted to the server. In most cases,
> having zeros simply leads to massive numbers of zeros stored in the
> database, which are not important when things get aggregated. Users are
> often not consistent about entering zeros, and trying to divine what the
> user's intent was, can be exceedingly difficult. This is the reason that
> the "Complete" button was implemented. With proper training and messaging,
> this can be used to indicate that the report it complete, and that
> everything which is blank, should be able to be assumed to be zero. Often
> people want to try and use a zero to indicate that a particular service is
> offered, but that there were simply no clients for that reporting period.
> The problem of course is whether the data entry staff understand this. I am
> not sure what the need for zeroes actually is in your case, but you may
> want to consider to use the completion information instead, if possible. We
> have seen numerous cases were more than 60% of the values stored in a DHIS2
> database are zeros. This leads to slower performance of analytics, as well
> as inflation of backup sizes, so I hope if you do change this, to think
> carefully about whether you really, really need all those zeros!
> Best regards,
> Jason
> On Thu, Nov 22, 2018 at 5:03 AM gerald thomas <gerald17006@xxxxxxxxx>
> wrote:
>> Dear Barnabas,
>> Thanks for your help.
>> The issue now is that we had been ignoring it all this time. Now, we want
>> to consider it again which means we will have to enable them as a batch by
>> API method but I am inquiring if the previous missing zeros will appear.
>> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba <akumbabarns@xxxxxxxxx>
>> wrote:
>>> Hello Gerald,
>>> Storing of zeros in the DHIS2 is configured during the Data Element
>>> Creation stage. There is an option where you need to enable the Data
>>> Element to store zero values (see attached screen shot).
>>> [image: image.png]
>>> Once that is done for all the Data Elements, then the Form will be able
>>> to store Zero values.
>>> Regards
>>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas <gerald17006@xxxxxxxxx>
>>> wrote:
>>>> Dear all,
>>>> We are looking at the WHO tool and there was a concern about the zeros
>>>> which are not storing in the PostgreSQL database.
>>>> Please is there any solution for these zeros not storing?
>>>> Is there another way for the WHO tool to differentiate between an
>>>> actual blank space and Zeros?
>>>> Thanks in advance for your contribution.
>>>> --
>>>> Regards,
>>>> Gerald
>>>> _______________________________________________
>>>> 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
>>> --
>>> Barnabas AKUMBA
>>> *Mobile:* +2348036195778
>>> *Skype:* barnabas.akumba
>> --
>> Regards,
>> Gerald
> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049


PNG image