dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olatitle@xxxxxxxxx>]

Hi,

And this is where you can search the mailing list's archives:
http://n2.nabble.com/DHIS-developers-list-f1563109.html

Also note that there is built in functionality in DHIS to create
completeness reports based on the subjective option to set every data entry
to complete or not (there is a "Set as complete" button on the bottom of
each form). Under Reports there is a section on Completeness where you can
get reports based on this. I am not familiar with how this works in detail
though.  Maybe Edem, Romain or Johan who have used this functionality in
Sierra Leone could explain? Or Lars Helge of course....

We've also had discussions and suggestions on more objective completeness
functionality, e.g. per data element, per data element group or per "set of
mandatory data elements".
Not sure what the status is on that right now. Maybe Lars could fill in.


Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@xxxxxxx|Tel:
+41 788216897
Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.


2010/1/26 Jason Pickering <jason.p.pickering@xxxxxxxxx>

> Hi Paul,
> You can export these reports to Excel no problem as they are BIRT reports.
>
> These reports (and associated SQL) analyze the ratio of blank data
> values to a numeric value, including zeroes. It would be simple enough
> to alter the SQL to analyze NULLS, zeros and actual data values, but
> it would require modification to the SQL that produces the
> materialized view.
>
> The issue of NULLS and zeroes, has a number of long and winding
> threads on this mailing list.  It might be good to search the archives
> and see if any of the discussion helps to clarify things.
>
> Regards,
> Jason
>
>
>
>
> On Tue, Jan 26, 2010 at 5:23 PM, Paul Amendola <Paul.Amendola@xxxxxxxxxx>
> wrote:
> > Hi Jason
> >
> > Thank you for the response and for the reports. Do you know if this has
> been looked at in terms of exporting the report tables to Excel? When
> exported to excel, all of the data elements are zero (both true zeros and
> incomplete data).
> >
> > Thanks again
> > Paul
> >
> > -----Original Message-----
> > From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
> > Sent: Monday, January 25, 2010 11:25 PM
> > To: Paul Amendola
> > Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Subject: Re: [Dhis2-devs] Question about Data Completeness
> >
> > Indeed, a topic dear to my heart and one that we have spent some time
> > working on.
> >
> > You can take a look at this...
> >
> >
> http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/files/head%3A/resources/zm_hmis<http://bazaar.launchpad.net/%7Edhis2-devs-core/dhis2/trunk/files/head%3A/resources/zm_hmis>
> >
> > In side are both SQL as well as BIRT reports that may give you, after
> > modification, what you want.
> >
> > Best regards,
> > Jason
> >
> >
> >
> > On Tue, Jan 26, 2010 at 12:35 AM, Paul Amendola
> > <Paul.Amendola@xxxxxxxxxx> wrote:
> >> When report tables are generated, the tables are populated with a zero,
> >> which makes it difficult to determine if the user had entered a zero
> into
> >> the database or left the data element blank. Is there a report that can
> be
> >> generated within DHIS that could be used to analyze data completeness by
> >> data element, instead of by report?
> >>
> >>
> >>
> >> Thanks,
> >>
> >> Paul
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>